Bill Todd <pg(at)dbginc(dot)com> writes:
> I am trying to restore a table named contact in the contact schema. I
> have tried two methods. The first is the command
> pg_restore --dbname=app --format=custom --schema=contact
> --table=contact.contact --username=postgres --single-transaction
The correct incantation is
You can use the qualified-name syntax in pg_dump's --table switch,
but nobody's gotten around to making pg_restore similarly bright.
> pg_restore -L contact.list contact.backup > result.txt
> This also runs without error but does not restore anything.
Well, in that form it's not supposed to do anything except emit SQL
into result.txt --- you probably want to use the -d switch, or else
pipe the SQL into psql.
regards, tom lane
In response to
pgsql-general by date
|Next:||From: Dave Page||Date: 2008-11-25 20:05:10|
|Subject: Re: Separate Sessions?? (View data <-> Query tool)|
|Previous:||From: Csaba Együd||Date: 2008-11-25 18:14:47|
|Subject: Separate Sessions?? (View data <-> Query tool)|