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