Search Postgresql Archives

pg_restore -L option

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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?

 


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux