pg_restore -L option
Started by Carlos Olivaalmost 22 years ago1 messagesgeneral
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?