pgsql-admin-owner@postgresql.org wrote on 10/25/2005 02:31:51 AM:
> It's possible with pg_restore to exclude that table on /restore/, but > that's not what you asked for.. > > On 25.10.2005 11:08, Gourish Singbal wrote: > > pg_dump does not allow you to accomplish this task for sure. > > > > On 10/20/05, Colton A Smith <smith@cs.utk.edu> wrote: > >> I don't think this is possible, but I want to make sure. Let's say I > >> have a database that I want to dump in its entirety, all except for one > >> particular table. Is there an option flag on pg_dump that accomplishes > >> this?
Here is an option: Dump into a test database, drop the table in the test db & dump to file: pg_dump originaldb | psql testdb < droptable.sql; pg_dump testdb > dumpfile
