Re: Dump a database excluding one table DATA?

Dmitry Koterov <dmitry(at)koterov(dot)ru> writes:
> Is there any way (or hack) to dump the whole database, but to exclude the
> DATA from a table within this dump? (DDL of the table should not be
> excluded: after restoring the data the excluded table should look "empty".)

The pg_staging tool allows you to do that quite easily, once you've done
the initial setup (involved, but nothing fancy).

https://github.com/dimitri/pg_staging
http://tapoueh.org/pgsql/pgstaging.html

If you want to exclude the table from the dumps though (data loss issues
are looking at you), what I would advice is create a dedicated schema
and skipping the whole schema at dump time, using the following option:

--exclude-schema=schema
Do not dump any schemas matching the schema
pattern. The pattern is interpreted according to the
same rules as for -n. -N can be given more than once
to exclude schemas matching any of several patterns.

Regards,
--
Dimitri Fontaine
http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support