theShadow89
10/23/2013 - 8:57 AM

dump postgress file

dump postgress file

pg_dump myDatabase --inserts -a -t table1 -t table2 > backup.sql;  
pg_dump myDatabase --inserts -a -t seq1 -t seq2 > backupSequences.sql;  

Parameters descriptions:  
  -a, --data-only dump only the data, not the schema  
  -t, --table=TABLE dump the named table(s) only  
  --inserts dump data as INSERT commands, rather than COPY