PostgreSQL &version; Reference Manual
The PostgreSQL Global Development Group
&legal;
Preface
The entries in this Reference Manual are
meant to provide in reasonable length an authorative, complete, and
formal summary about the respective subjects. More information
about the use of PostgreSQL, in
narrative, tutorial, or example form, may be found in other parts
of the PostgreSQL documentation set.
See the cross-references listed on each reference page.
The Reference Manual entries are also
available as traditional man
pages.
SQL Commands
This part contains reference information for the
SQL commands supported by
PostgreSQL. By SQL
the
language in general is meant; information about the standards
conformance and compatibility of each command can be found on the
respective reference page.
&abort;
&alterDatabase;
&alterGroup;
&alterTable;
&alterUser;
&analyze;
&begin;
&checkpoint;
&close;
&cluster;
&commentOn;
&commit;
©Table;
&createAggregate;
&createConstraint;
&createDatabase;
&createDomain;
&createFunction;
&createGroup;
&createIndex;
&createLanguage;
&createOperator;
&createRule;
&createSequence;
&createTable;
&createTableAs;
&createTrigger;
&createType;
&createUser;
&createView;
&declare;
&delete;
&dropAggregate;
&dropDatabase;
&dropDomain;
&dropFunction;
&dropGroup;
&dropIndex;
&dropLanguage;
&dropOperator;
&dropRule;
&dropSequence;
&dropTable;
&dropTrigger;
&dropType
&dropUser;
&dropView;
&end;
&explain;
&fetch;
&grant;
&insert;
&listen;
&load;
&lock;
&move;
¬ify;
&reindex;
&reset;
&revoke;
&rollback;
&select;
&selectInto;
&set;
&setConstraints;
&setSessionAuth;
&setTransaction;
&show;
&truncate;
&unlisten;
&update;
&vacuum;
PostgreSQL Client Applications
This part contains reference information for
PostgreSQL client applications and
utilities. Not all of these commands are of general utility, some
may 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.
&createdb;
&createlang;
&createuser;
&dropdb;
&droplang;
&dropuser;
&ecpgRef;
&pgAccess;
&pgConfig;
&pgDump;
&pgDumpall;
&pgRestore;
&psqlRef;
&pgTclSh;
&pgTkSh;
&vacuumdb;
PostgreSQL Server Applications
This part contains reference information for
PostgreSQL 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 .
&initdb;
&initlocation;
&ipcclean;
&pgCtl;
&pgPasswd;
&postgres;
&postmaster;