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

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: 2007-01-22 23:48:04
Message-ID: b35603930701221548o299e0056qf89132bdc75c0c43@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
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

In response to

Responses

pgsql-novice by date

Next:From: Alan HodgsonDate: 2007-01-22 23:53:08
Subject: Re: Restore single table from pg_dumpall.
Previous:From: Jim StalewskiDate: 2007-01-22 23:05:56
Subject: Restore single table from pg_dumpall.

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