Re: Dump all except some tables?

WireSpot <wirespot@gmail.com> writes:
> On 10/6/05, A. Kretschmer <akretschmer@despammed.com> wrote:
>> You can use the -t more than once.
>>
>> pg_dump -U foobar database -t foo -t foo1

> Yes, pg_dump doesn't complain. But it only takes the first one into
> consideration. I only get one table in the dump.

Right.  That's on the TODO list but not done yet :-(.

Berend gave you the right advice: dump the whole database using
pg_dump -Fc, then use pg_restore's features for selective restore.

            regards, tom lane