WireSpot <wirespot(at)gmail(dot)com> writes:
> On 10/6/05, A. Kretschmer <akretschmer(at)despammed(dot)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