Home • Explore • Blog • CI
☰



postgresql
13th chunk of `doc/src/sgml/ref/pg_dump.sgml`
3b5395a1d380c80795c3d6aaf979b1bf07b34f568d1cab750000000100000fa0
   </para>
       <para>
        To exclude data for all tables in the database, see <option>--schema-only</option>
        or <option>--statistics-only</option>.
       </para>
      </listitem>
     </varlistentry>

     <varlistentry>
      <term><option>--exclude-table-data-and-children=<replaceable class="parameter">pattern</replaceable></option></term>
      <listitem>
       <para>
        This is the same as the <option>--exclude-table-data</option> option,
        except that it also excludes data of any partitions or inheritance
        child tables of the table(s) matching the
        <replaceable class="parameter">pattern</replaceable>.
       </para>
      </listitem>
     </varlistentry>

     <varlistentry>
      <term><option>--extra-float-digits=<replaceable class="parameter">ndigits</replaceable></option></term>
      <listitem>
       <para>
        Use the specified value of <option>extra_float_digits</option> when dumping
        floating-point data, instead of the maximum available precision.
        Routine dumps made for backup purposes should not use this option.
       </para>
      </listitem>
     </varlistentry>

     <varlistentry>
      <term><option>--filter=<replaceable class="parameter">filename</replaceable></option></term>
      <listitem>
       <para>
        Specify a filename from which to read patterns for objects to include
        or exclude from the dump. The patterns are interpreted according to the
        same rules as the corresponding options:
        <option>-t</option>/<option>--table</option>,
        <option>--table-and-children</option>,
        <option>-T</option>/<option>--exclude-table</option>, and
        <option>--exclude-table-and-children</option> for tables,
        <option>-n</option>/<option>--schema</option> and
        <option>-N</option>/<option>--exclude-schema</option> for schemas,
        <option>--include-foreign-data</option> for data on foreign servers,
        <option>--exclude-table-data</option> and
        <option>--exclude-table-data-and-children</option> for table data, and
        <option>-e</option>/<option>--extension</option> and
        <option>--exclude-extension</option> for extensions.
        To read from <literal>STDIN</literal>, use <filename>-</filename> as the
        filename.  The <option>--filter</option> option can be specified in
        conjunction with the above listed options for including or excluding
        objects, and can also be specified more than once for multiple filter
        files.
       </para>

       <para>
        The file lists one object pattern per row, with the following format:
<synopsis>
{ include | exclude } { extension | foreign_data | table | table_and_children | table_data | table_data_and_children | schema } <replaceable class="parameter">PATTERN</replaceable>
</synopsis>
       </para>

       <para>
        The first keyword specifies whether the objects matched by the pattern
        are to be included or excluded. The second keyword specifies the type
        of object to be filtered using the pattern:
        <itemizedlist>
         <listitem>
          <para>
           <literal>extension</literal>: extensions. This works like the
           <option>-e</option>/<option>--extension</option> or
           <option>--exclude-extension</option> option.
          </para>
         </listitem>
         <listitem>
          <para>
           <literal>foreign_data</literal>: data on foreign servers. This works like
           the <option>--include-foreign-data</option> option. This keyword can
           only be used with the <literal>include</literal> keyword.
          </para>
         </listitem>
         <listitem>
          <para>
           <literal>table</literal>: tables. This works like the
           <option>-t</option>/<option>--table</option> or
           <option>-T</option>/<option>--exclude-table</option> option.
          </para>
         </listitem>
         <listitem>
          <para>
Title: pg_dump Options: `--extra-float-digits` and `--filter`
Summary
This section describes pg_dump options `--extra-float-digits` and `--filter`. `--extra-float-digits` specifies the precision for dumping floating-point data, which should not be used for routine backups. `--filter` specifies a file containing patterns for including or excluding objects from the dump, such as tables, schemas, extensions, and foreign data, using include or exclude directives along with the object type and pattern. The filter option supports multiple files and can be used with other inclusion/exclusion options.