Pavunkumar
Pavunkumar

Reputation: 5345

Taking dump of the database without getting specific table records :Postgres

Can any one tell me , How can i take database dump using pg_dump without getting specific table records.

Upvotes: 1

Views: 1508

Answers (1)

user948581
user948581

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:

  1. dump your full database
  2. restore it as another name (so you now have a copy of your original DB)
  3. DELETE the records you wish to get rid of
  4. 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.

Upvotes: 1

Related Questions