Reputation: 5345
Can any one tell me , How can i take database dump using pg_dump
without getting specific table records.
Upvotes: 1
Views: 1508
Reputation:
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:
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.
Upvotes: 1