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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-novice by date

  From Date Subject
Next Message Alan Hodgson 2007-01-22 23:53:08 Re: Restore single table from pg_dumpall.
Previous Message Jim Stalewski 2007-01-22 23:05:56 Restore single table from pg_dumpall.