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
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 |