SQL statements [YSQL]

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 category.

Data definition language (DDL)

Statement	Description
ALTER DATABASE	Change database definition
ALTER DOMAIN	Change domain definition
ALTER FOREIGN DATA WRAPPER	Change foreign data wrapper definition
ALTER FOREIGN TABLE	Change foreign table definition
ALTER INDEX	Change index definition
ALTER MATERIALIZED VIEW	Change materialized view definition
ALTER PUBLICATION	Change publication definition
ALTER SEQUENCE	Change sequence definition
ALTER SERVER	Change foreign server definition
ALTER SCHEMA	Change schema 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 FOREIGN DATA WRAPPER	Create a foreign-data wrapper
CREATE FOREIGN TABLE	Create a foreign table
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 PUBLICATION	Create a publication
CREATE RULE	Create a rule
CREATE SCHEMA	Create a schema (namespace)
CREATE SEQUENCE	Create a sequence generator
CREATE SERVER	Create a foreign server
CREATE TABLE	Create an empty table
CREATE TABLE AS	Create a table from the results of a executing a SELECT
CREATE TABLESPACE	Create a tablespace
CREATE TRIGGER	Create a trigger
CREATE TYPE	Create a type
CREATE USER MAPPING	Create a user mapping
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 FOREIGN DATA WRAPPER	Drop a foreign-data wrapper
DROP FOREIGN TABLE	Drop a foreign table
DROP FUNCTION	Delete a function
DROP INDEX	Delete an index from a database
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 PUBLICATION	Delete a publication
DROP RULE	Delete a rule
DROP SCHEMA	Delete a schema from the system
DROP SEQUENCE	Delete a sequence generator
DROP SERVER	Drop a foreign server
DROP TABLE	Delete a table from a database
DROP TABLESPACE	Delete a tablespace from the cluster
DROP TYPE	Delete a user-defined type
DROP TRIGGER	Delete a trigger
DROP VIEW	Drop a view
IMPORT FOREIGN SCHEMA	Import a foreign schema
REFRESH MATERIALIZED VIEW	Refresh a materialized view
TRUNCATE	Clear all rows from a table

Data manipulation language (DML)

Statement	Description
CLOSE	Remove a cursor
DECLARE	Create a cursor
DELETE	Delete rows from a table
FETCH	Fetch rows from a cursor
INSERT	Insert rows into a table
MOVE	Move the current position within a cursor
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
START TRANSACTION	Start 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 run-time parameter to its default value
SET	Set the value of a run-time parameter
SHOW	Show the value of a run-time 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

Streaming replication protocol statements

Statement	Description
CREATE_REPLICATION_SLOT	Create a replication slot
DROP_REPLICATION_SLOT	Drop a replication slot
START_REPLICATION	Start streaming from a replication slot

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