doc/src/sgml/reference.sgml

   1 <!-- $PostgreSQL$ -->
   2
   3 <part id="reference">
   4  <title>Reference</title>
   5
   6  <partintro>
   7   <para>
   8    The entries in this Reference are meant to provide in reasonable
   9    length an authoritative, complete, and formal summary about their
  10    respective subjects.  More information about the use of
  11    <productname>PostgreSQL</productname>, in narrative, tutorial, or
  12    example form, can be found in other parts of this book.  See the
  13    cross-references listed on each reference page.
  14   </para>
  15
  16   <para>
  17    The reference entries are also available as traditional
  18    <quote>man</quote> pages.
  19   </para>
  20  </partintro>
  21
  22  <reference id="sql-commands">
  23   <title>SQL Commands</title>
  24
  25   <partintro>
  26    <para>
  27     This part contains reference information for the
  28     <acronym>SQL</acronym> commands supported by
  29     <productname>PostgreSQL</productname>.  By <quote>SQL</quote> the
  30     language in general is meant; information about the standards
  31     conformance and compatibility of each command can be found on the
  32     respective reference page.
  33    </para>
  34   </partintro>
  35
  36    &abort;
  37    &alterAggregate;
  38    &alterConversion;
  39    &alterDatabase;
  40    &alterDomain;
  41    &alterForeignDataWrapper;
  42    &alterFunction;
  43    &alterGroup;
  44    &alterIndex;
  45    &alterLanguage;
  46    &alterOperator;
  47    &alterOperatorClass;
  48    &alterOperatorFamily;
  49    &alterRole;
  50    &alterSchema;
  51    &alterSequence;
  52    &alterServer;
  53    &alterTable;
  54    &alterTableSpace;
  55    &alterTSConfig;
  56    &alterTSDictionary;
  57    &alterTSParser;
  58    &alterTSTemplate;
  59    &alterTrigger;
  60    &alterType;
  61    &alterUser;
  62    &alterUserMapping;
  63    &alterView;
  64    &analyze;
  65    &begin;
  66    &checkpoint;
  67    &close;
  68    &cluster;
  69    &commentOn;
  70    &commit;
  71    &commitPrepared;
  72    &copyTable;
  73    &createAggregate;
  74    &createCast;
  75    &createConstraint;
  76    &createConversion;
  77    &createDatabase;
  78    &createDomain;
  79    &createForeignDataWrapper;
  80    &createFunction;
  81    &createGroup;
  82    &createIndex;
  83    &createLanguage;
  84    &createOperator;
  85    &createOperatorClass;
  86    &createOperatorFamily;
  87    &createRole;
  88    &createRule;
  89    &createSchema;
  90    &createSequence;
  91    &createServer;
  92    &createTable;
  93    &createTableAs;
  94    &createTableSpace;
  95    &createTSConfig;
  96    &createTSDictionary;
  97    &createTSParser;
  98    &createTSTemplate;
  99    &createTrigger;
 100    &createType;
 101    &createUser;
 102    &createUserMapping;
 103    &createView;
 104    &deallocate;
 105    &declare;
 106    &delete;
 107    &discard;
 108    &dropAggregate;
 109    &dropCast;
 110    &dropConversion;
 111    &dropDatabase;
 112    &dropDomain;
 113    &dropForeignDataWrapper;
 114    &dropFunction;
 115    &dropGroup;
 116    &dropIndex;
 117    &dropLanguage;
 118    &dropOperator;
 119    &dropOperatorClass;
 120    &dropOperatorFamily;
 121    &dropOwned;
 122    &dropRole;
 123    &dropRule;
 124    &dropSchema;
 125    &dropSequence;
 126    &dropServer;
 127    &dropTable;
 128    &dropTableSpace;
 129    &dropTSConfig;
 130    &dropTSDictionary;
 131    &dropTSParser;
 132    &dropTSTemplate;
 133    &dropTrigger;
 134    &dropType;
 135    &dropUser;
 136    &dropUserMapping;
 137    &dropView;
 138    &end;
 139    &execute;
 140    &explain;
 141    &fetch;
 142    &grant;
 143    &insert;
 144    &listen;
 145    &load;
 146    &lock;
 147    &move;
 148    &notify;
 149    &prepare;
 150    &prepareTransaction;
 151    &reassignOwned;
 152    &reindex;
 153    &releaseSavepoint;
 154    &reset;
 155    &revoke;
 156    &rollback;
 157    &rollbackPrepared;
 158    &rollbackTo;
 159    &savepoint;
 160    &select;
 161    &selectInto;
 162    &set;
 163    &setConstraints;
 164    &setRole;
 165    &setSessionAuth;
 166    &setTransaction;
 167    &show;
 168    &startTransaction;
 169    &truncate;
 170    &unlisten;
 171    &update;
 172    &vacuum;
 173    &values;
 174
 175  </reference>
 176
 177  <reference id="reference-client">
 178   <title>PostgreSQL Client Applications</title>
 179
 180   <partintro>
 181    <para>
 182     This part contains reference information for
 183     <productname>PostgreSQL</productname> client applications and
 184     utilities.  Not all of these commands are of general utility, some
 185     might require special privileges.  The common feature of these
 186     applications is that they can be run on any host, independent of
 187     where the database server resides.
 188    </para>
 189   </partintro>
 190
 191    &clusterdb;
 192    &createdb;
 193    &createlang;
 194    &createuser;
 195    &dropdb;
 196    &droplang;
 197    &dropuser;
 198    &ecpgRef;
 199    &pgConfig;
 200    &pgDump;
 201    &pgDumpall;
 202    &pgRestore;
 203    &psqlRef;
 204    &reindexdb;
 205    &vacuumdb;
 206
 207  </reference>
 208
 209  <reference id="reference-server">
 210   <title>PostgreSQL Server Applications</title>
 211
 212   <partintro>
 213    <para>
 214     This part contains reference information for
 215     <productname>PostgreSQL</productname> server applications and
 216     support utilities.  These commands can only be run usefully on the
 217     host where the database server resides.  Other utility programs
 218     are listed in <xref linkend="reference-client">.
 219    </para>
 220   </partintro>
 221
 222    &initdb;
 223    &pgControldata;
 224    &pgCtl;
 225    &pgResetxlog;
 226    &postgres;
 227    &postmaster;
 228
 229  </reference>
 230
 231 </part>