| From: | Carlos <Carlos(at)pbsinet(dot)com> |
|---|---|
| To: | "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org> |
| Subject: | pg_restore -L option |
| Date: | 2004-05-07 19:00:58 |
| Message-ID: | E148BE531B8AD311922E005004D3EEA102A87EA5@xchserver.pbsinet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Could someone clarify the use of the -L option in pg_restore? I have a
pg_dump of a database (options -Ft -b) and I want to restore most of the
dump with the exception of one table into another database. Can I do the
following?:
1) restore the tar file of the dump into a "list" file with pg_restore
-l
2) comment out the line for the table that I want to exclude, and
3) restore the tar file with the following command: pg_restore -a -L
<list file> -d <dbname> <tar file name>
Thanks in advance for your response?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rick Gigger | 2004-05-07 19:03:14 | Re: pgFoundry Open For Business |
| Previous Message | Mike Mascari | 2004-05-07 18:53:22 | Re: any experience with multithreaded pg apps? |