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