diff options
| -rw-r--r-- | doc/src/sgml/ref/pg_dump.sgml | 12 |
1 files changed, 9 insertions, 3 deletions
diff --git a/doc/src/sgml/ref/pg_dump.sgml b/doc/src/sgml/ref/pg_dump.sgml index 3e48498db28..478686e15da 100644 --- a/doc/src/sgml/ref/pg_dump.sgml +++ b/doc/src/sgml/ref/pg_dump.sgml @@ -516,9 +516,7 @@ PostgreSQL documentation <listitem> <para> Dump only tables with names matching - <replaceable class="parameter">pattern</replaceable>. - For this purpose, <quote>table</quote> includes views, materialized views, - sequences, and foreign tables. Multiple tables + <replaceable class="parameter">pattern</replaceable>. Multiple tables can be selected by writing multiple <option>-t</option> switches. The <replaceable class="parameter">pattern</replaceable> parameter is interpreted as a pattern according to the same rules used by @@ -531,6 +529,14 @@ PostgreSQL documentation </para> <para> + As well as tables, this option can be used to dump views, materialized views, + foreign tables, and sequence definitions. However it will not dump the contents + of views or materialized views, and the contents of foreign tables will only be + dumped if the corresponding foreign server is specified with + <option>--include-foreign-data</option>. + </para> + + <para> The <option>-n</option> and <option>-N</option> switches have no effect when <option>-t</option> is used, because tables selected by <option>-t</option> will be dumped regardless of those switches, and non-table objects will not |