Postgres Pro
Downloads
Home   >   mailing lists

Re: Restore single table from pg_dumpall. - Mailing list pgsql-novice

From Andrej Ricnik-Bay
Subject Re: Restore single table from pg_dumpall.
Date
Msg-id b35603930701221548o299e0056qf89132bdc75c0c43@mail.gmail.com
Whole thread Raw
In response to Restore single table from pg_dumpall.  ("Jim Stalewski" <JStalewski@VisaLighting.com>)
Responses Re: Restore single table from pg_dumpall.
List pgsql-novice
Tree view 
On 1/23/07, Jim Stalewski <JStalewski@visalighting.com> wrote:

> I have been asked by a programmer to restore a single table from a
> PG_DUMPALL backup.
>
> Is this possible, and if so, would anyone be able to tell me please, what
> PSQL options and switches are required?  Running PostgreSQL 8.1.3.
Not sure whether this is an option for you, but I'd make a copy,
fire up vim and strip all I don't want out of the copy.

If I wanted to be able to restore individual databases I'd dump
them individually.


Cheers,
Andrej

pgsql-novice by date:

Previous
From: "Jim Stalewski"
Date:
Subject: Restore single table from pg_dumpall.
Next
From: Alan Hodgson
Date:
Subject: Re: Restore single table from pg_dumpall.