Categorized list of SQL statements

The YSQL statements are compatible with the SQL dialect that PostgreSQL supports. The sidebar lists all of the YSQL statements in alphabetical order. The following tables list them by catagory.

Data definition language (DDL)

Statement	Description
ALTER DATABASE	Change database definition
ALTER DOMAIN	Change domain definition
ALTER SEQUENCE	Change sequence definition
ALTER TABLE	Change table definition
COMMENT	Set, update, or remove a comment on a database object
CREATE AGGREGATE	Create an aggregate
CREATE CAST	Create a cast
CREATE DATABASE	Create a database
CREATE DOMAIN	Create a user-defined data type with optional constraints
CREATE EXTENSION	Load an extension
CREATE FUNCTION	Create a function
CREATE INDEX	Create an index
CREATE MATERIALIZED VIEW	Create a materialized view
CREATE OPERATOR	Create an operator
CREATE OPERATOR CLASS	Create an operator class
CREATE PROCEDURE	Create a procedure
CREATE RULE	Create a rule
CREATE SCHEMA	Create a schema (namespace)
CREATE SEQUENCE	Create a sequence generator
CREATE TABLE	Create an empty table
CREATE TABLE AS	Create a table from the results of a executing a SELECT
CREATE TRIGGER	Create a trigger
CREATE TYPE	Create a type
CREATE VIEW	Create a view
DROP AGGREGATE	Delete an aggregate
DROP CAST	Delete a cast
DROP DATABASE	Delete a database from the system
DROP DOMAIN	Delete a domain
DROP EXTENSION	Delete an extension
DROP FUNCTION	Delete a function
DROP MATERIALIZED VIEW	Drop a materialized view
DROP OPERATOR	Delete an operator
DROP OPERATOR CLASS	Delete an operator class
DROP PROCEDURE	Delete a procedure
DROP RULE	Delete a rule
DROP SEQUENCE	Delete a sequence generator
DROP TABLE	Delete a table from a database
DROP TYPE	Delete a user-defined type
DROP TRIGGER	Delete a trigger
REFRESH MATERIALIZED VIEW	Refresh a materialized view
TRUNCATE	Clear all rows from a table

Data manipulation language (DML)

Statement	Description
DELETE	Delete rows from a table
INSERT	Insert rows into a table
SELECT	Select rows from a table
UPDATE	Update rows in a table

Data control language (DCL)

Statement	Description
ALTER DEFAULT PRIVILEGES	Define default privileges
ALTER GROUP	Alter a group
ALTER POLICY	Alter a row level security policy
ALTER ROLE	Alter a role (user or group)
ALTER USER	Alter a user
CREATE GROUP	Create a group (role)
CREATE POLICY	Create a row level security policy
CREATE ROLE	Create a role (user or group)
CREATE USER	Create a user (role)
DROP GROUP	Drop a group
DROP POLICY	Drop a row level security policy
DROP ROLE	Drop a role (user or group)
DROP OWNED	Drop owned objects
DROP USER	Drop a user
GRANT	Grant permissions
REASSIGN OWNED	Reassign owned objects
REVOKE	Revoke permissions
SET ROLE	Set a role
SET SESSION AUTHORIZATION	Set session authorization

Transaction control language (TCL)

Statement	Description
ABORT	Roll back a transaction
BEGIN	Start a transaction
COMMIT	Commit a transaction
END	Commit a transaction
LOCK	Lock a table
ROLLBACK	Roll back a transaction
SET CONSTRAINTS	Set constraints on current transaction
SET TRANSACTION	Set transaction behaviors
SHOW TRANSACTION	Show properties of a transaction
SAVEPOINT	Create a new savepoint
ROLLBACK TO	Rollback to a savepoint
RELEASE	Release a savepoint

Session and system control

Statement	Description
RESET	Reset a parameter to factory settings
SET	Set a system, session, or transactional parameter
SHOW	Show value of a system, session, or transactional parameter

Performance control

Statement	Description
DEALLOCATE	Deallocate a prepared statement
EXECUTE	Execute a prepared statement
EXPLAIN	Explain an execution plan for a statement
PREPARE	Prepare a statement

Other statements

Statement	Description
ANALYZE	Collect statistics about a database
COPY	Copy data between tables and files
DO	Execute an anonymous PL/pgSQL code block