</varlistentry>

<varlistentry>

<term><option>-n <replaceable class="parameter">schema</replaceable></option></term>

<term><option>--schema=<replaceable class="parameter">schema</replaceable></option></term>

<term><option>-n <replaceable class="parameter">pattern</replaceable></option></term>

<term><option>--schema=<replaceable class="parameter">pattern</replaceable></option></term>

<listitem>

<para>

Dump only schemas matching <replaceable

class="parameter">schema</replaceable>; this selects both the

class="parameter">pattern</replaceable>; this selects both the

schema itself, and all its contained objects. When this option is

not specified, all non-system schemas in the target database will be

dumped. Multiple schemas can be

selected by writing multiple <option>-n</option> switches.Also, the

<replaceable class="parameter">schema</replaceable> parameter is

selected by writing multiple <option>-n</option> switches.The

<replaceable class="parameter">pattern</replaceable> parameter is

interpreted as a pattern according to the same rules used by

<application>psql</application>'s <literal>\d</literal> commands (see <xref

linkend="app-psql-patterns" endterm="app-psql-patterns-title"/>),

</varlistentry>

<varlistentry>

<term><option>-N <replaceable class="parameter">schema</replaceable></option></term>

<term><option>--exclude-schema=<replaceable class="parameter">schema</replaceable></option></term>

<term><option>-N <replaceable class="parameter">pattern</replaceable></option></term>

<term><option>--exclude-schema=<replaceable class="parameter">pattern</replaceable></option></term>

<listitem>

<para>

Do not dump any schemas matchingthe<replaceable

class="parameter">schema</replaceable> pattern. The pattern is

Do not dump any schemas matching <replaceable

class="parameter">pattern</replaceable>. The pattern is

interpreted according to the same rules as for <option>-n</option>.

<option>-N</option> can be given more than once to exclude schemas

matching any of several patterns.

</varlistentry>

<varlistentry>

<term><option>-t <replaceable class="parameter">table</replaceable></option></term>

<term><option>--table=<replaceable class="parameter">table</replaceable></option></term>

<term><option>-t <replaceable class="parameter">pattern</replaceable></option></term>

<term><option>--table=<replaceable class="parameter">pattern</replaceable></option></term>

<listitem>

<para>

Dump only tables with names matching

<replaceable class="parameter">table</replaceable>.

<replaceable class="parameter">pattern</replaceable>.

For this purpose, <quote>table</quote> includes views, materialized views,

sequences, and foreign tables. Multiple tables

can be selected by writing multiple <option>-t</option> switches.Also, the

<replaceable class="parameter">table</replaceable> parameter is

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

<application>psql</application>'s <literal>\d</literal> commands (see <xref

linkend="app-psql-patterns" endterm="app-psql-patterns-title"/>),

</varlistentry>

<varlistentry>

<term><option>-T <replaceable class="parameter">table</replaceable></option></term>

<term><option>--exclude-table=<replaceable class="parameter">table</replaceable></option></term>

<term><option>-T <replaceable class="parameter">pattern</replaceable></option></term>

<term><option>--exclude-table=<replaceable class="parameter">pattern</replaceable></option></term>

<listitem>

<para>

Do not dump any tables matchingthe<replaceable

class="parameter">table</replaceable> pattern. The pattern is

Do not dump any tables matching <replaceable

class="parameter">pattern</replaceable>. The pattern is

interpreted according to the same rules as for <option>-t</option>.

<option>-T</option> can be given more than once to exclude tables

matching any of several patterns.

</varlistentry>

<varlistentry>

<term><option>--exclude-table-data=<replaceable class="parameter">table</replaceable></option></term>

<term><option>--exclude-table-data=<replaceable class="parameter">pattern</replaceable></option></term>

<listitem>

<para>

Do not dump data for any tables matchingthe<replaceable

class="parameter">table</replaceable> pattern. The pattern is

Do not dump data for any tables matching <replaceable

class="parameter">pattern</replaceable>. The pattern is

interpreted according to the same rules as for <option>-t</option>.

<option>--exclude-table-data</option> can be given more than once to

exclude tables matching any of several patterns. This option is

printf(_(" -c, --clean clean (drop) database objects before recreating\n"));

printf(_(" -C, --create include commands to create database in dump\n"));

printf(_(" -E, --encoding=ENCODING dump the data in encoding ENCODING\n"));

printf(_(" -n, --schema=SCHEMAdump thenamed schema(s) only\n"));

printf(_(" -N, --exclude-schema=SCHEMAdo NOT dump thenamed schema(s)\n"));

printf(_(" -n, --schema=PATTERN dump thespecified schema(s) only\n"));

printf(_(" -N, --exclude-schema=PATTERNdo NOT dump thespecified schema(s)\n"));

printf(_(" -O, --no-owner skip restoration of object ownership in\n"

" plain-text format\n"));

printf(_(" -s, --schema-only dump only the schema, no data\n"));

printf(_(" -S, --superuser=NAME superuser user name to use in plain-text format\n"));

printf(_(" -t, --table=TABLEdump thenamed table(s) only\n"));

printf(_(" -T, --exclude-table=TABLEdo NOT dump thenamed table(s)\n"));

printf(_(" -t, --table=PATTERN dump thespecified table(s) only\n"));

printf(_(" -T, --exclude-table=PATTERNdo NOT dump thespecified table(s)\n"));

printf(_(" -x, --no-privileges do not dump privileges (grant/revoke)\n"));

printf(_(" --binary-upgrade for use by upgrade utilities only\n"));

printf(_(" --column-inserts dump data as INSERT commands with column names\n"));

printf(_(" --disable-dollar-quoting disable dollar quoting, use SQL standard quoting\n"));

printf(_(" --disable-triggers disable triggers during data-only restore\n"));

printf(_(" --enable-row-security enable row security (dump only content user has\n"

" access to)\n"));

printf(_(" --exclude-table-data=TABLEdo NOT dump data for thenamed table(s)\n"));

printf(_(" --exclude-table-data=PATTERNdo NOT dump data for thespecified table(s)\n"));

printf(_(" --extra-float-digits=NUM override default setting for extra_float_digits\n"));

printf(_(" --if-exists use IF EXISTS when dropping objects\n"));

printf(_(" --inserts dump data as INSERT commands, rather than COPY\n"));