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?