Postgres SHOW CREATE TABLE equivalent« an older post
a newer one »Find files of a particular type in Finder

Postgres dump all but one table

Snippet Written with a loving hand by kitt some time around 14:07 on 30 December 2019

Those versions and logs tables? You don't really want them in the dump. So, don't include them, use --exclude-table.

pg_dump --exclude-table=TABLE_TO_EXCLUDE $DATABASE_URL
Source: 
https://stackoverflow.com/questions/31671244/how-to-dump-a-postgres-db-excluding…
#postgres
#postgresql

Add new comment

Plain text

  • No HTML tags allowed.
  • Lines and paragraphs break automatically.