Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Restore single table from pg_dumpall.
- From: "Andrej Ricnik-Bay" <andrej(dot)groups(at)gmail(dot)com>
- To: "Jim Stalewski" <JStalewski(at)visalighting(dot)com>
- Cc: pgsql-novice(at)postgresql(dot)org
- Subject: Re: Restore single table from pg_dumpall.
- Date: Tue, 23 Jan 2007 12:48:04 +1300
On 1/23/07, Jim Stalewski <JStalewski(at)visalighting(dot)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
- Follow-Ups:
- Re: Restore single table from pg_dumpall.
- From: Alan Hodgson
- Re: Restore single table from pg_dumpall.
- References:
- Restore single table from pg_dumpall.
- From: Jim Stalewski
- Restore single table from pg_dumpall.
- Prev by Date: Restore single table from pg_dumpall.
- Next by Date: Re: Restore single table from pg_dumpall.
- Previous by thread: Restore single table from pg_dumpall.
- Next by thread: Re: Restore single table from pg_dumpall.
- Indexes: