pg_restore question

From: "Johnson, Shaunn" <SJohnson6(at)bcbsm(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: pg_restore question
Date: 2002-05-06 16:48:34
Message-ID: 73309C2FDD95D11192E60008C7B1D5BB0452E3A2@snt452.corp.bcbsm.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Running Postgres 7.1.3 on RedHat Linux 7.2.

I'm looking for examples of using pg_restore.
My goal is to restore ONE table of which the
backup is created by using pg_dump.

This is how I created the dump:

pg_dump -u -t table_name database | /bin/gzip > table_name.gz

Now, I'm trying to review the pg_restore docs and I'm
having a hard time trying to figure out the correct
syntax of restoring the one table. The docs that
I'm reading only seems to talk about the database.
Yes, there is a -t option, but I don't know in what
order that should go in.

Any examples are appreciate.

Thanks.

-X

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2002-05-06 17:03:46 Re: Foreign Key Option
Previous Message Tom Lane 2002-05-06 16:44:03 Re: Subject: bool / vacuum full bug followup part 2