要从几个表中获取数据:
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
这就是我想要的:)
谢谢大家!