Re: Dump all except some tables? - Mailing list pgsql-general

From Tom Lane
Subject Re: Dump all except some tables?
Date
Msg-id 16900.1128606682@sss.pgh.pa.us
Whole thread Raw
In response to Re: Dump all except some tables?  (WireSpot <wirespot@gmail.com>)
Responses Re: Dump all except some tables?
List pgsql-general
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

pgsql-general by date:

Previous
From: Ly Lam Ngoc Bich
Date:
Subject: How to uninstall Postgres on Iinux.
Next
From: Tatsuo Ishii
Date:
Subject: Re: PostgreSQL 8.1 vs. MySQL 5.0?