Re: restore single table - Mailing list pgsql-general

From Richard Huxton
Subject Re: restore single table
Date
Msg-id 003a01c10fa7$99593540$1001a8c0@archonet.com
Whole thread Raw
In response to restore single table  (Liz Pelletier <liz@plandepot.com>)
List pgsql-general
From: "Liz Pelletier" <liz@plandepot.com>

> If I have a dump of myDB, and I want to restore only two tables from
> this dump, is there a way to do this? Or do I have to restore the entire
> db?
>
> (BTW, using 7.1 on a Debian box.)

Try pg_restore if you used pg_dump's new option (never tried it myself).

If you dumped your database as text (INSERTs/COPY) it's cut & paste time (or
a couple of greps and a short perl script).

- Richard Huxton


pgsql-general by date:

Previous
From: "Kapil Tilwani"
Date:
Subject: Re: THIS IS NOT RELATED TO THE RDBMS BUT PLEEEEEEEEEEEEEASE
Next
From: will trillich
Date:
Subject: Re: psql -l