Re: restoring one table?

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Brian Maguire" <bmaguire(at)vantage(dot)com>
Cc: "pgsql general" <pgsql-general(at)postgresql(dot)org>, "Kevin MacClay" <kmacclay(at)vantage(dot)com>
Subject: Re: restoring one table?
Date: 2008-08-08 06:49:19
Message-ID: dcc563d10808072349x1bf56997ye612600d2f5d927e@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Aug 7, 2008 at 4:34 PM, Brian Maguire <bmaguire(at)vantage(dot)com> wrote:
> We need to restore one table from a backup. What is the proper way to do this?
>
> Our backup command looks like this:
>
> pg_dump -C -Fc -S postgresql mydatabase > today.backup.sqlc
>
> I am using PostgreSQL 8.1.

You have read this page, right:

http://www.postgresql.org/docs/8.1/interactive/app-pgrestore.html

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Glyn Astill 2008-08-08 08:46:10 Re: Initdb problem on debian mips cobalt: Bus error
Previous Message Lennin Caro 2008-08-08 03:45:06 Re: Create Table Dinamic