WireSpot <[EMAIL PROTECTED]> writes:
> On 10/6/05, A. Kretschmer <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster