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