Re: Pg-restore - Mailing list pgsql-bugs

From Richard Huxton
Subject Re: Pg-restore
Date
Msg-id 43FC647B.4060707@archonet.com
Whole thread Raw
In response to Pg-restore  ("Ramzi M. Zeid" <ramzi.zeid@beecell.com>)
List pgsql-bugs
Ramzi M. Zeid wrote:
> Hello all,
>
> Is the any way or command to make a restore for a single table from a TAR
> file that contains many table to another DB.

pg_restore -t <tablename> will work if it's a dump in the correct
format. See the manuals for details.

If it's just a bunch of INSERTS in a file you've built yourself, then
clearly not.

--
   Richard Huxton
   Archonet Ltd

pgsql-bugs by date:

Previous
From: Richard Huxton
Date:
Subject: Re: BUG #2278: problem with grants
Next
From: Tom Lane
Date:
Subject: Re: Problem with dump/restore and inheritance