reference.sgml

<!-- $PostgreSQL: pgsql/doc/src/sgml/reference.sgml,v 1.67 2008/12/19 16:25:16 petere Exp $ -->

<part id="reference">
 <title>Reference</title>

 <partintro>
  <para>
   The entries in this Reference are meant to provide in reasonable
   length an authoritative, complete, and formal summary about their
   respective subjects.  More information about the use of
   <productname>PostgreSQL</productname>, in narrative, tutorial, or
   example form, can be found in other parts of this book.  See the
   cross-references listed on each reference page.
  </para>

  <para>
   The reference entries are also available as traditional
   <quote>man</quote> pages.
  </para>
 </partintro>

 <reference id="sql-commands">
  <title>SQL Commands</title>

  <partintro>
   <para>
    This part contains reference information for the
    <acronym>SQL</acronym> commands supported by
    <productname>PostgreSQL</productname>.  By <quote>SQL</quote> the
    language in general is meant; information about the standards
    conformance and compatibility of each command can be found on the
    respective reference page.
   </para>
  </partintro>

   &abort;
   &alterAggregate;
   &alterConversion;
   &alterDatabase;
   &alterDomain;
   &alterForeignDataWrapper;
   &alterFunction;
   &alterGroup;
   &alterIndex;
   &alterLanguage;
   &alterOperator;
   &alterOperatorClass;
   &alterOperatorFamily;
   &alterRole;
   &alterSchema;
   &alterSequence;
   &alterServer;
   &alterTable;
   &alterTableSpace;
   &alterTSConfig;
   &alterTSDictionary;
   &alterTSParser;
   &alterTSTemplate;
   &alterTrigger;
   &alterType;
   &alterUser;
   &alterUserMapping;
   &alterView;
   &analyze;
   &begin;
   &checkpoint;
   &close;
   &cluster;
   &commentOn;
   &commit;
   &commitPrepared;
   &copyTable;
   &createAggregate;
   &createCast;
   &createConstraint;
   &createConversion;
   &createDatabase;
   &createDomain;
   &createForeignDataWrapper;
   &createFunction;
   &createGroup;
   &createIndex;
   &createLanguage;
   &createOperator;
   &createOperatorClass;
   &createOperatorFamily;
   &createRole;
   &createRule;
   &createSchema;
   &createSequence;
   &createServer;
   &createTable;
   &createTableAs;
   &createTableSpace;
   &createTSConfig;
   &createTSDictionary;
   &createTSParser;
   &createTSTemplate;
   &createTrigger;
   &createType;
   &createUser;
   &createUserMapping;
   &createView;
   &deallocate;
   &declare;
   &delete;
   &discard;
   &dropAggregate;
   &dropCast;
   &dropConversion;
   &dropDatabase;
   &dropDomain;
   &dropForeignDataWrapper;
   &dropFunction;
   &dropGroup;
   &dropIndex;
   &dropLanguage;
   &dropOperator;
   &dropOperatorClass;
   &dropOperatorFamily;
   &dropOwned;
   &dropRole;
   &dropRule;
   &dropSchema;
   &dropSequence;
   &dropServer;
   &dropTable;
   &dropTableSpace;
   &dropTSConfig;
   &dropTSDictionary;
   &dropTSParser;
   &dropTSTemplate;
   &dropTrigger;
   &dropType;
   &dropUser;
   &dropUserMapping;
   &dropView;
   &end;
   &execute;
   &explain;
   &fetch;
   &grant;
   &insert;
   &listen;
   &load;
   &lock;
   &move;
   &notify;
   &prepare;
   &prepareTransaction;
   &reassignOwned;
   &reindex;
   &releaseSavepoint;
   &reset;
   &revoke;
   &rollback;
   &rollbackPrepared;
   &rollbackTo;
   &savepoint;
   &select;
   &selectInto;
   &set;
   &setConstraints;
   &setRole;
   &setSessionAuth;
   &setTransaction;
   &show;
   &startTransaction;
   &truncate;
   &unlisten;
   &update;
   &vacuum;
   &values;

 </reference>

 <reference id="reference-client">
  <title>PostgreSQL Client Applications</title>

  <partintro>
   <para>
    This part contains reference information for
    <productname>PostgreSQL</productname> client applications and
    utilities.  Not all of these commands are of general utility, some
    might require special privileges.  The common feature of these
    applications is that they can be run on any host, independent of
    where the database server resides.
   </para>
  </partintro>

   &clusterdb;
   &createdb;
   &createlang;
   &createuser;
   &dropdb;
   &droplang;
   &dropuser;
   &ecpgRef;
   &pgConfig;
   &pgDump;
   &pgDumpall;
   &pgRestore;
   &psqlRef;
   &reindexdb;
   &vacuumdb;

 </reference>

 <reference id="reference-server">
  <title>PostgreSQL Server Applications</title>

  <partintro>
   <para>
    This part contains reference information for
    <productname>PostgreSQL</productname> server applications and
    support utilities.  These commands can only be run usefully on the
    host where the database server resides.  Other utility programs
    are listed in <xref linkend="reference-client">.
   </para>
  </partintro>

   &initdb;
   &pgControldata;
   &pgCtl;
   &pgResetxlog;
   &postgres;
   &postmaster;

 </reference>

</part>