Consider a production database with a few dozens of normal-size tables, and a handful of huge tables.
I am looking for a convenient way to pg_dump
the database content, excluding the few huge tables, for my own local laptop. I can easily dump a small sample of the huge tables using \COPY
, if I occasionally need to address these tables.
If I use the --exclude-table=table
argument, both the schema and the data of the huge table is omitted, which breaks queries expecting these table on the local development environment.
Is there a way to dump a data base with a complete schema, excluding the content of some given tables?