pg_restore -L option

Started by Carlos Olivaalmost 22 years ago1 messagesgeneral
Jump to latest
#1Carlos Oliva
carlos@pbsinet.com

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?