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 PostgreSQL, in narrative,
tutorial, or example form, can be found in other parts of this book. See
the cross-references listed on each reference page.

The reference entries are also available as traditional "man" pages.

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 ALTERAGGREGATE ALTERCOLLATION ALTERCONVERSION ALTERDATABASE
ALTERDEFAULTPRIVILEGES ALTERDOMAIN ALTEREVENTTRIGGER ALTEREXTENSION
ALTERFOREIGNDATAWRAPPER ALTERFOREIGNTABLE ALTERFUNCTION ALTERGROUP
ALTERINDEX ALTERLANGUAGE ALTERLARGEOBJECT ALTERMATERIALIZEDVIEW
ALTEROPERATOR ALTEROPERATORCLASS ALTEROPERATORFAMILY ALTERPOLICY
ALTERPROCEDURE ALTERPUBLICATION ALTERROLE ALTERROUTINE ALTERRULE
ALTERSCHEMA ALTERSEQUENCE ALTERSERVER ALTERSTATISTICS ALTERSUBSCRIPTION
ALTERSYSTEM ALTERTABLE ALTERTABLESPACE ALTERTSCONFIG ALTERTSDICTIONARY
ALTERTSPARSER ALTERTSTEMPLATE ALTERTRIGGER ALTERTYPE ALTERUSER
ALTERUSERMAPPING ALTERVIEW ANALYZE BEGIN CALL CHECKPOINT CLOSE CLUSTER
COMMENTON COMMIT COMMITPREPARED COPYTABLE CREATEACCESSMETHOD
CREATEAGGREGATE CREATECAST CREATECOLLATION CREATECONVERSION
CREATEDATABASE CREATEDOMAIN CREATEEVENTTRIGGER CREATEEXTENSION
CREATEFOREIGNDATAWRAPPER CREATEFOREIGNTABLE CREATEFUNCTION CREATEGROUP
CREATEINDEX CREATELANGUAGE CREATEMATERIALIZEDVIEW CREATEOPERATOR
CREATEOPERATORCLASS CREATEOPERATORFAMILY CREATEPOLICY CREATEPROCEDURE
CREATEPUBLICATION CREATEROLE CREATERULE CREATESCHEMA CREATESEQUENCE
CREATESERVER CREATESTATISTICS CREATESUBSCRIPTION CREATETABLE
CREATETABLEAS CREATETABLESPACE CREATETSCONFIG CREATETSDICTIONARY
CREATETSPARSER CREATETSTEMPLATE CREATETRANSFORM CREATETRIGGER CREATETYPE
CREATEUSER CREATEUSERMAPPING CREATEVIEW DEALLOCATE DECLARE DELETE
DISCARD DO DROPACCESSMETHOD DROPAGGREGATE DROPCAST DROPCOLLATION
DROPCONVERSION DROPDATABASE DROPDOMAIN DROPEVENTTRIGGER DROPEXTENSION
DROPFOREIGNDATAWRAPPER DROPFOREIGNTABLE DROPFUNCTION DROPGROUP DROPINDEX
DROPLANGUAGE DROPMATERIALIZEDVIEW DROPOPERATOR DROPOPERATORCLASS
DROPOPERATORFAMILY DROPOWNED DROPPOLICY DROPPROCEDURE DROPPUBLICATION
DROPROLE DROPROUTINE DROPRULE DROPSCHEMA DROPSEQUENCE DROPSERVER
DROPSTATISTICS DROPSUBSCRIPTION DROPTABLE DROPTABLESPACE DROPTSCONFIG
DROPTSDICTIONARY DROPTSPARSER DROPTSTEMPLATE DROPTRANSFORM DROPTRIGGER
DROPTYPE DROPUSER DROPUSERMAPPING DROPVIEW END EXECUTE EXPLAIN FETCH
GRANT IMPORTFOREIGNSCHEMA INSERT LISTEN LOAD LOCK MERGE MOVE NOTIFY
PREPARE PREPARETRANSACTION REASSIGNOWNED REFRESHMATERIALIZEDVIEW REINDEX
RELEASESAVEPOINT RESET REVOKE ROLLBACK ROLLBACKPREPARED ROLLBACKTO
SAVEPOINT SECURITYLABEL SELECT SELECTINTO SET SETCONSTRAINTS SETROLE
SETSESSIONAUTH SETTRANSACTION SHOW STARTTRANSACTION TRUNCATE UNLISTEN
UPDATE VACUUM VALUES

This part contains reference information for PostgreSQL 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.

When specified on the command line, user and database names have their
case preserved MDASH the presence of spaces or special characters might
require quoting. Table names and other identifiers do not have their
case preserved, except where documented, and might require quoting.

CLUSTERDB CREATEDB CREATEUSER DROPDB DROPUSER ECPGREF PGAMCHECK
PGBASEBACKUP PGBENCH PGCONFIG PGDUMP PGDUMPALL PGISREADY PGRECEIVEWAL
PGRECVLOGICAL PGRESTORE PGVERIFYBACKUP PSQLREF REINDEXDB VACUUMDB

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 [reference\_title](#reference-client).

INITDB PGARCHIVECLEANUP PGCHECKSUMS PGCONTROLDATA PGCTL PGRESETWAL
PGREWIND PGTESTFSYNC PGTESTTIMING PGUPGRADE PGWALDUMP POSTGRES
POSTMASTER
