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?