From: | "Mitch Vincent" <mvincent(at)cablespeed(dot)com> |
---|---|
To: | <liz(at)plandepot(dot)com>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: restore single table |
Date: | 2001-07-18 16:02:53 |
Message-ID: | 002501c10fa3$1a5ddf10$1251000a@Mitch |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
You could grab the entries from the backup file but it require a little
coding (Some creative use of grep/awk could probably do it)...
Or load the entire backup into a temp database then dump from the temp
database only the tables you want and import then into whichever database
you'd like...
*shrug* either way, you have to jump through a few hoops...
Good luck!
-Mitch
----- Original Message -----
From: "Liz Pelletier" <liz(at)plandepot(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Sent: Wednesday, July 18, 2001 11:46 AM
Subject: [GENERAL] restore single table
> 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.)
>
> Thanks in advance,
> Liz
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-07-18 16:06:33 | Re: Errors in logs |
Previous Message | Tom Lane | 2001-07-18 15:57:35 | Re: psql -l |