Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group