WireSpot <wirespot@xxxxxxxxx> writes: > On 10/6/05, A. Kretschmer <akretschmer@xxxxxxxxxxxxx> 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