Changes between Version 76 and Version 77 of InstallationGuidelines/PostgreSQL

Timestamp:

10/02/17 16:18:49 (8 years ago)

Author:

Fran Boon

Comment:

pg_restore specific tables

InstallationGuidelines/PostgreSQL

@@ -264 +264 @@
 }}}
 
+If wanting to be specific about which tables to restore, you can use:
+{{{
+pg_restore -t table | psql
+}}}
+
+If you want to exclude a table, there is no equivalent argument, so you can sue the following procedure:
+{{{
+pg_restore -l $pgdump_file > restore.pgdump.list
+# Open that restore.pgdump.list file in an editor, and insert an ; in front of the lines to not import
+pg_restore -L restore.pgdump.list | psql
+}}}
 == Remote Access ==
 Say that you want to provide access for an external reporting tool.