PostgreSQL dump/restore

Question

I don't want to Dump the entire table but only certain records in a table in my dump file and later restore the same.
P.S.: I want to do the same for more than 1 table in my database but dump it in a single file.
Is this possible? If yes then how do i go about it?

Thank in advance.

Answer 1

As @Pondlife mentioned in his answer had to use COPY command but did not solve my Problem of getting all the dump data into a single file.
So from the idea given by Craig Ringer made individual files for each table and got all the files compressed into a single archive file.
For restore uncompressed the archive to generate individual files later used them to restore the Tables.

Had to answer my own question so it might help somebody.

Answer 2

The COPY command?

Answer 3

Should be possible using Jailer.

Answer 4

create temp_tables from sqlquery

sqlquery can be formed as projection like 'select columns from table'

then use pg_dump to dump all temporary tables using --table option. pgadmin can help dumping tables in a single file here.

Restore all temp tables from pgadmin and run INSERT query on main table.