diff options
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/pg_dump.sgml | 24 | ||||
| -rw-r--r-- | doc/src/sgml/ref/pg_restore.sgml | 23 |
2 files changed, 44 insertions, 3 deletions
diff --git a/doc/src/sgml/ref/pg_dump.sgml b/doc/src/sgml/ref/pg_dump.sgml index cf6d689918a..710051a4fd1 100644 --- a/doc/src/sgml/ref/pg_dump.sgml +++ b/doc/src/sgml/ref/pg_dump.sgml @@ -116,9 +116,7 @@ PostgreSQL documentation </para> <para> - This option is only meaningful for the plain-text format. For - the archive formats, you can specify the option when you - call <command>pg_restore</command>. + This option is equivalent to specifying <option>--section=data</>. </para> </listitem> </varlistentry> @@ -408,10 +406,30 @@ PostgreSQL documentation To exclude table data for only a subset of tables in the database, see <option>--exclude-table-data</>. </para> + <para> + This option is equivalent to specifying + <option>--section=pre-data --section=post-data</>. + </para> </listitem> </varlistentry> <varlistentry> + <term><option>--section=<replaceable class="parameter">sectionname</replaceable></option></term> + <listitem> + <para> + Only dump the named section. The name can be one of <option>pre-data</>, <option>data</> + and <option>post-data</>. + This option can be specified more than once. The default is to dump all sections. + </para> + <para> + Post-data items consist of definitions of indexes, triggers, rules + and constraints other than check constraints. + Pre-data items consist of all other data definition items. + </para> + </listitem> + </varlistentry> + + <varlistentry> <term><option>-S <replaceable class="parameter">username</replaceable></option></term> <term><option>--superuser=<replaceable class="parameter">username</replaceable></option></term> <listitem> diff --git a/doc/src/sgml/ref/pg_restore.sgml b/doc/src/sgml/ref/pg_restore.sgml index be11d176cd4..a28faf87a4a 100644 --- a/doc/src/sgml/ref/pg_restore.sgml +++ b/doc/src/sgml/ref/pg_restore.sgml @@ -93,6 +93,9 @@ <para> Restore only the data, not the schema (data definitions). </para> + <para> + This option is equivalent to specifying <option>--section=data</>. + </para> </listitem> </varlistentry> @@ -359,6 +362,10 @@ (Do not confuse this with the <option>--schema</> option, which uses the word <quote>schema</> in a different meaning.) </para> + <para> + This option is equivalent to specifying + <option>--section=pre-data --section=post-data</>. + </para> </listitem> </varlistentry> @@ -505,6 +512,22 @@ </varlistentry> <varlistentry> + <term><option>--section=<replaceable class="parameter">sectionname</replaceable></option></term> + <listitem> + <para> + Only restore the named section. The name can be one of <option>pre-data</>, <option>data</> + and <option>post-data</>. + This option can be specified more than once. The default is to restore all sections. + </para> + <para> + Post-data items consist of definitions of indexes, triggers, rules + and constraints other than check constraints. + Pre-data items consist of all other data definition items. + </para> + </listitem> + </varlistentry> + + <varlistentry> <term><option>--use-set-session-authorization</option></term> <listitem> <para> |