Chapter 14. SQL Commands

Table of Contents
ABORT — Aborts the current transaction
ALTER TABLE — Modifies table properties
ALTER USER — Modifies user account information
BEGIN — Begins a transaction in chained mode
CLOSE — Close a cursor
CLUSTER — Gives storage clustering advice to the backend
COMMIT — Commits the current transaction
COPY — Copies data between files and tables
CREATE AGGREGATE — Defines a new aggregate function
CREATE DATABASE — Creates a new database
CREATE FUNCTION — Defines a new function
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
CREATE TRIGGER — Creates a new trigger
CREATE TYPE — Defines a new base data type
CREATE USER — Creates account information for a new user
CREATE VIEW — Constructs a virtual table
DECLARE — Defines a cursor for table access
DELETE — Deletes rows from a table
DROP AGGREGATE — Removes the definition of an aggregate function
DROP DATABASE — Destroys an existing database
DROP FUNCTION — Removes a user-defined C function
DROP INDEX — Removes an index from a database
DROP LANGUAGE — Removes a user-defined procedural language
DROP OPERATOR — Removes an operator from the database
DROP RULE — Removes an existing rule from the database
DROP SEQUENCE — Removes an existing sequence
DROP TABLE — Removes existing tables from a database
DROP TRIGGER — Removes the definition of a trigger
DROP TYPE — Removes a user-defined type from the system catalogs
DROP USER — Removes an user account information
DROP VIEW — Removes an existing view from a database
EXPLAIN — Shows statement execution details
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 notification on a notify condition
LOAD — Dynamically loads an object file
LOCK — Explicit lock of a table inside a transaction
MOVE — Moves cursor position
NOTIFY — Signals all frontends and backends listening on a notify condition
RESET — Restores run-time parameters for session to default values
REVOKE — Revokes access privilege from a user, a group or all users.
ROLLBACK — Aborts the current transaction
SELECT — Retrieve rows from a table or view.
SELECT INTO — Create a new table from an existing table or view
SET — Set run-time parameters for session
SHOW — Shows run-time parameters for session
UNLISTEN — Stop listening for notification
UPDATE — Replaces values of columns in a table
VACUUM — Clean and analyze a Postgres database

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