PostgreSQL Essential Reference

Table of Commands

The following table organizes the supported SQL commands by task.

	Creation	Destruction	Use/Modify
Database	CREATE DATABASE	DROP DATABASE	COMMENT LOAD VACUUM
Table/Index	CREATE TABLE CREATE INDEX CREATE VIEW	DROP TABLE DROP INDEX DROP VIEW TRUNCATE	COMMENT SELECT EXPLAIN ALTER TABLE ALTER INDEX COPY UPDATE INSERT DELETE SELECT INTO VACUUM CLUSTER
Constraints	CREATE TRIGGER CREATE CONSTRAINT CREATE RULE CREATE SEQUENCE	DROP TRIGGER DROP CONSTRAINT DROP RULE DROP SEQUENCE	COMMENT
User	CREATE USER CREATE GROUP	DROP USER DROP GROUP	ALTER USER ALTER GROUP GRANT REVOKE
Session/Transaction	SET DECLARE BEGIN	CLOSE ABORT COMMIT ROLLBACK END	SHOW RESET FETCH MOVE LISTEN UNLISTEN NOTIFY LOCK UNLOCK
Misc	CREATE AGGREGATE CREATE ...