Can any one tell me , How can i take database dump using pg_dump without getting specific table records.
Add a comment |
1 Answer
If you want a table-wide filter, you can use either --exclude-table=table or --table=table to resp. exclude tables or include only the tables you want.
If you want to "filter out" some records, then you have no direct option to do it. My best advice is to:
- dump your full database
- restore it as another name (so you now have a copy of your original DB)
- DELETE the records you wish to get rid of
- dump the database
This is of course quite rudimentary, and there might be other solutions suitable to your needs. E.g. dump using plain text format then manually edit the dump to remove the rows.
1 Comment
Scott Marlowe
Another way is to create a new table with just the records you want and dump that. select * into holdingtable from actualtable where id in (1,2,5,6); then pg_dump -t holdingtable