pg_restore question - Mailing list pgsql-general

From Johnson, Shaunn
Subject pg_restore question
Date
Msg-id 73309C2FDD95D11192E60008C7B1D5BB0452E3A2@snt452.corp.bcbsm.com
Whole thread Raw
List 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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Subject: bool / vacuum full bug followup part 2
Next
From: Stephan Szabo
Date:
Subject: Re: Foreign Key Option