Re: Pg-restore

From: Richard Huxton <dev(at)archonet(dot)com>
To: "Ramzi M(dot) Zeid" <ramzi(dot)zeid(at)beecell(dot)com>
Cc: Andrew Nykolyn <nykolyn(at)ngc(dot)com>, Andras Got <andrej1981(at)gmail(dot)com>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Pg-restore
Date: 2006-02-22 13:17:47
Message-ID: 43FC647B.4060707@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

  • Pg-restore at 2006-02-22 12:00:56 from Ramzi M. Zeid

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2006-02-22 15:11:51 Re: Problem with dump/restore and inheritance
Previous Message Richard Huxton 2006-02-22 13:15:30 Re: BUG #2278: problem with grants