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
SELECT
EXPLAIN
ALTER TABLE
ALTER INDEX
COPY
UPDATE
INSERT
DELETE
SELECT INTO
CLUSTER
Constraints
CREATE TRIGGER
CREATE CONSTRAINT
CREATE RULE
CREATE SEQUENCE
DROP TRIGGER
DROP CONSTRAINT
DROP RULE
DROP SEQUENCE
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 OPERATOR
CREATE TYPE
CREATE LANGUAGE
CREATE FUNCTION
DROP AGGREGATE
DROP OPERATOR
DROP TYPE
DROP LANGUAGE
DROP FUNCTION