I. SQL Commands

This is reference information for the SQL commands supported by Postgres.

Table of Contents
ABORT — Aborts the current transaction
ALTER GROUP — Add users to a group, remove users from a group
ALTER TABLE — Modifies table properties
ALTER USER — Modifies user account information
BEGIN — Begins a transaction in chained mode
CHECKPOINT — Force transaction log checkpoint
CLOSE — Close a cursor
CLUSTER — Gives storage clustering advice to the server
COMMENT — Add comment to an object
COMMIT — Commits the current transaction
COPY — Copies data between files and tables
CREATE AGGREGATE — Defines a new aggregate function
CREATE CONSTRAINT TRIGGER — Create a trigger to support a constraint
CREATE DATABASE — Creates a new database
CREATE FUNCTION — Defines a new function
CREATE GROUP — Creates a new group
CREATE INDEX — Constructs a secondary index
CREATE LANGUAGE — Defines a new language for functions
CREATE OPERATOR — Defines a new user operator
CREATE RULE — Defines a new rule
CREATE SEQUENCE — Creates a new sequence number generator
CREATE TABLE — Creates a new table
CREATE TABLE AS — Creates a new table from the results of a SELECT
CREATE TRIGGER — Creates a new trigger
CREATE TYPE — Defines a new base data type
CREATE USER — Creates a new database user
CREATE VIEW — Constructs a virtual table
DECLARE — Defines a cursor for table access
DELETE — Removes rows from a table
DROP AGGREGATE — Removes the definition of an aggregate function
DROP DATABASE — Removes an existing database
DROP FUNCTION — Removes a user-defined C function
DROP GROUP — Removes a group
DROP INDEX — Removes existing indexes from a database
DROP LANGUAGE — Removes a user-defined procedural language
DROP OPERATOR — Removes an operator from the database
DROP RULE — Removes existing rules from the database
DROP SEQUENCE — Removes existing sequences from a database
DROP TABLE — Removes existing tables from a database
DROP TRIGGER — Removes the definition of a trigger
DROP TYPE — Removes user-defined types from the system catalogs
DROP USER — Removes a user
DROP VIEW — Removes existing views from a database
END — Commits the current transaction
EXPLAIN — Shows statement execution plan
FETCH — Gets rows using a cursor
GRANT — Grants access privilege to a user, a group or all users
INSERT — Inserts new rows into a table
LISTEN — Listen for a response on a notify condition
LOAD — Dynamically loads an object file
LOCK — Explicitly lock a table inside a transaction
MOVE — Moves cursor position
NOTIFY — Signals all frontends and backends listening on a notify condition
REINDEX — Recover corrupted system indexes under stand-alone Postgres
RESET — Restores run-time parameters to default values
REVOKE — Revokes access privilege from a user, a group or all users.
ROLLBACK — Aborts the current transaction
SELECT — Retrieves rows from a table or view
SELECT INTO — Creates a new table from the results of a SELECT
SET — Set run-time parameters
SET CONSTRAINTS — Set the constraint mode of the current SQL-transaction
SET TRANSACTION — Set the characteristics of the current SQL-transaction
SHOW — Shows run-time parameters
TRUNCATE — Empty a table
UNLISTEN — Stop listening for notification
UPDATE — Replaces values of columns in a table
VACUUM — Clean and analyze a Postgres database