Home Explore Blog CI



postgresql

2nd chunk of `doc/src/sgml/oid2name.sgml`
dd297f42a0b12574443d5438c4cb1ba0bd385a64af6a86460000000100000faa
 <term><option>--system-objects</option></term>
     <listitem><para>include system objects (those in
      <option>information_schema</option>, <option>pg_toast</option>
      and <option>pg_catalog</option> schemas).
     </para></listitem>
    </varlistentry>

    <varlistentry>
     <term><option>-t <replaceable class="parameter">tablename_pattern</replaceable></option></term>
     <term><option>--table=<replaceable class="parameter">tablename_pattern</replaceable></option></term>
     <listitem><para>show info for table(s) matching <replaceable class="parameter">tablename_pattern</replaceable>.</para></listitem>
    </varlistentry>

    <varlistentry>
     <term><option>-V</option></term>
     <term><option>--version</option></term>
     <listitem>
      <para>
       Print the <application>oid2name</application> version and exit.
      </para>
     </listitem>
    </varlistentry>

    <varlistentry>
     <term><option>-x</option></term>
     <term><option>--extended</option></term>
     <listitem><para>display more information about each object shown: tablespace name,
      schema name, and OID.
     </para></listitem>
    </varlistentry>

    <varlistentry>
     <term><option>-?</option></term>
     <term><option>--help</option></term>
     <listitem>
      <para>
       Show help about <application>oid2name</application> command line
       arguments, and exit.
      </para>
     </listitem>
    </varlistentry>
   </variablelist>
  </para>

  <para>
   <application>oid2name</application> also accepts the following command-line
   arguments for connection parameters:

   <variablelist>
    <varlistentry>
     <term><option>-d <replaceable class="parameter">database</replaceable></option></term>
     <term><option>--dbname=<replaceable class="parameter">database</replaceable></option></term>
     <listitem><para>database to connect to.</para></listitem>
    </varlistentry>

    <varlistentry>
     <term><option>-h <replaceable class="parameter">host</replaceable></option></term>
     <term><option>--host=<replaceable class="parameter">host</replaceable></option></term>
     <listitem><para>database server's host.</para></listitem>
    </varlistentry>

    <varlistentry>
     <term><option>-H <replaceable class="parameter">host</replaceable></option></term>
     <listitem><para>database server's host.  Use of this parameter is
     <emphasis>deprecated</emphasis> as of
     <productname>PostgreSQL</productname> 12.</para></listitem>
    </varlistentry>

    <varlistentry>
     <term><option>-p <replaceable class="parameter">port</replaceable></option></term>
     <term><option>--port=<replaceable class="parameter">port</replaceable></option></term>
     <listitem><para>database server's port.</para></listitem>
    </varlistentry>

    <varlistentry>
     <term><option>-U <replaceable class="parameter">username</replaceable></option></term>
     <term><option>--username=<replaceable class="parameter">username</replaceable></option></term>
     <listitem><para>user name to connect as.</para></listitem>
    </varlistentry>

   </variablelist>
  </para>

  <para>
   To display specific tables, select which tables to show by
   using <option>-o</option>, <option>-f</option> and/or <option>-t</option>.
   <option>-o</option> takes an OID,
   <option>-f</option> takes a filenode,
   and <option>-t</option> takes a table name (actually, it's a <literal>LIKE</literal>
   pattern, so you can use things like <literal>foo%</literal>).
   You can use as many
   of these options as you like, and the listing will include all objects
   matched by any of the options.  But note that these options can only
   show objects in the database given by <option>-d</option>.
  </para>

  <para>
   If you don't give any of <option>-o</option>, <option>-f</option> or <option>-t</option>,
   but do give <option>-d</option>, it will list all tables in the database
   named by <option>-d</option>.  In this mode, the <option>-S</option> and
   <option>-i</option>

Title: oid2name Command-Line Options
Summary
The oid2name utility program accepts various command-line options to customize its behavior, including options to specify database connection parameters, filter results by OID, filenode, or table name, and control the amount of information displayed, with additional options to include system objects, indexes, and sequences, or to display version and help information.