SQL Statements

These topics document the syntax, parameters, and examples for a selection of SQL statements, grouped by the object they act on.

Databases and tablespaces

CREATE DATABASE · ALTER DATABASE · DROP DATABASE · CREATE TABLESPACE · ALTER TABLESPACE · DROP TABLESPACE

Schemas, rules, and types

CREATE SCHEMA · DROP SCHEMA · ALTER RULE · DROP RULE · DROP TYPE · DROP EXTENSION

Tables and indexes

CREATE TABLE · CREATE TABLE AS · ALTER TABLE · DROP TABLE · TRUNCATE · DROP EXTERNAL TABLE · CREATE INDEX · DROP INDEX

Views and materialized views

CREATE VIEW · DROP VIEW · CREATE MATERIALIZED VIEW · REFRESH MATERIALIZED VIEW · DROP MATERIALIZED VIEW

Querying and modifying data

SELECT · INSERT · UPDATE · DELETE · COPY

Query plans and table maintenance

EXPLAIN · ANALYZE · VACUUM

Roles and privileges

CREATE ROLE · DROP ROLE · DROP USER · SET ROLE · GRANT · REVOKE

Transaction control

BEGIN · START TRANSACTION · SET TRANSACTION · SAVEPOINT · ROLLBACK TO SAVEPOINT · COMMIT · END · ROLLBACK · ABORT