pg_restore -L option - Mailing list pgsql-general

From Carlos
Subject pg_restore -L option
Date
Msg-id E148BE531B8AD311922E005004D3EEA102A87EA5@xchserver.pbsinet.com
Whole thread Raw
List 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?

 

pgsql-general by date:

Previous
From: Ben
Date:
Subject: Re: any experience with multithreaded pg apps?
Next
From: Mike Mascari
Date:
Subject: Re: any experience with multithreaded pg apps?