3

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.

Improve this question

4 Answers 4

Reset to default
2

The COPY command?

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

2

Should be possible using Jailer.

Improve this answer

1 Comment

@ZigArt but I am not using java.
1

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.

Improve this answer

3 Comments

Yes. pg_dump --host hostname --port portno --username "username" --format custom --verbose --file "filename" --table "schema.temp_table" "dbname"
have u tried it? because I error saying No matching Table were found
Check if tablename is given as schemaname.tablename in pg_dump args
0

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.

Improve this answer

Comments

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.