Practical PostgreSQL

Chapter 14. PostgreSQL Command Reference

This command reference covers each of the major SQL commands supported by PostgreSQL. It contains both standard SQL commands (e.g., INSERT, SELECT) and PostgreSQL-specific commands (e.g., CREATE OPERATOR, CREATE TYPE).

Each reference entry is broken up into three sections: a synopsis, a description, and an examples section. The synopsis contains a syntax diagram, parameter explanation, and a list of possible results from executing the command. The description briefly summarizes the general use of the command. The examples section contains at least one functional example of using the command.