---
title: "SQL Commands"
id: sql-commands
pg_version: "20devel"
---

SQL CommandsThis part contains reference information for the SQL commands supported by PostgreSQL. By "SQL" the language in general is meant; information about the standards conformance and compatibility of each command can be found on the respective reference page. 

## Table of Contents

- [ABORT](sql-abort.md)
- [ALTER AGGREGATE](sql-alteraggregate.md)
- [ALTER COLLATION](sql-altercollation.md)
- [ALTER CONVERSION](sql-alterconversion.md)
- [ALTER DATABASE](sql-alterdatabase.md)
- [ALTER DEFAULT PRIVILEGES](sql-alterdefaultprivileges.md)
- [ALTER DOMAIN](sql-alterdomain.md)
- [ALTER EVENT TRIGGER](sql-altereventtrigger.md)
- [ALTER EXTENSION](sql-alterextension.md)
- [ALTER FOREIGN DATA WRAPPER](sql-alterforeigndatawrapper.md)
- [ALTER FOREIGN TABLE](sql-alterforeigntable.md)
- [ALTER FUNCTION](sql-alterfunction.md)
- [ALTER GROUP](sql-altergroup.md)
- [ALTER INDEX](sql-alterindex.md)
- [ALTER LANGUAGE](sql-alterlanguage.md)
- [ALTER LARGE OBJECT](sql-alterlargeobject.md)
- [ALTER MATERIALIZED VIEW](sql-altermaterializedview.md)
- [ALTER OPERATOR](sql-alteroperator.md)
- [ALTER OPERATOR CLASS](sql-alteropclass.md)
- [ALTER OPERATOR FAMILY](sql-alteropfamily.md)
- [ALTER POLICY](sql-alterpolicy.md)
- [ALTER PROCEDURE](sql-alterprocedure.md)
- [ALTER PROPERTY GRAPH](sql-alter-property-graph.md)
- [ALTER PUBLICATION](sql-alterpublication.md)
- [ALTER ROLE](sql-alterrole.md)
- [ALTER ROUTINE](sql-alterroutine.md)
- [ALTER RULE](sql-alterrule.md)
- [ALTER SCHEMA](sql-alterschema.md)
- [ALTER SEQUENCE](sql-altersequence.md)
- [ALTER SERVER](sql-alterserver.md)
- [ALTER STATISTICS](sql-alterstatistics.md)
- [ALTER SUBSCRIPTION](sql-altersubscription.md)
- [ALTER SYSTEM](sql-altersystem.md)
- [ALTER TABLE](sql-altertable.md)
- [ALTER TABLESPACE](sql-altertablespace.md)
- [ALTER TEXT SEARCH CONFIGURATION](sql-altertsconfig.md)
- [ALTER TEXT SEARCH DICTIONARY](sql-altertsdictionary.md)
- [ALTER TEXT SEARCH PARSER](sql-altertsparser.md)
- [ALTER TEXT SEARCH TEMPLATE](sql-altertstemplate.md)
- [ALTER TRIGGER](sql-altertrigger.md)
- [ALTER TYPE](sql-altertype.md)
- [ALTER USER](sql-alteruser.md)
- [ALTER USER MAPPING](sql-alterusermapping.md)
- [ALTER VIEW](sql-alterview.md)
- [ANALYZE](sql-analyze.md)
- [BEGIN](sql-begin.md)
- [CALL](sql-call.md)
- [CHECKPOINT](sql-checkpoint.md)
- [CLOSE](sql-close.md)
- [CLUSTER](sql-cluster.md)
- [COMMENT](sql-comment.md)
- [COMMIT](sql-commit.md)
- [COMMIT PREPARED](sql-commit-prepared.md)
- [COPY](sql-copy.md)
- [CREATE ACCESS METHOD](sql-create-access-method.md)
- [CREATE AGGREGATE](sql-createaggregate.md)
- [CREATE CAST](sql-createcast.md)
- [CREATE COLLATION](sql-createcollation.md)
- [CREATE CONVERSION](sql-createconversion.md)
- [CREATE DATABASE](sql-createdatabase.md)
- [CREATE DOMAIN](sql-createdomain.md)
- [CREATE EVENT TRIGGER](sql-createeventtrigger.md)
- [CREATE EXTENSION](sql-createextension.md)
- [CREATE FOREIGN DATA WRAPPER](sql-createforeigndatawrapper.md)
- [CREATE FOREIGN TABLE](sql-createforeigntable.md)
- [CREATE FUNCTION](sql-createfunction.md)
- [CREATE GROUP](sql-creategroup.md)
- [CREATE INDEX](sql-createindex.md)
- [CREATE LANGUAGE](sql-createlanguage.md)
- [CREATE MATERIALIZED VIEW](sql-creatematerializedview.md)
- [CREATE OPERATOR](sql-createoperator.md)
- [CREATE OPERATOR CLASS](sql-createopclass.md)
- [CREATE OPERATOR FAMILY](sql-createopfamily.md)
- [CREATE POLICY](sql-createpolicy.md)
- [CREATE PROCEDURE](sql-createprocedure.md)
- [CREATE PROPERTY GRAPH](sql-create-property-graph.md)
- [CREATE PUBLICATION](sql-createpublication.md)
- [CREATE ROLE](sql-createrole.md)
- [CREATE RULE](sql-createrule.md)
- [CREATE SCHEMA](sql-createschema.md)
- [CREATE SEQUENCE](sql-createsequence.md)
- [CREATE SERVER](sql-createserver.md)
- [CREATE STATISTICS](sql-createstatistics.md)
- [CREATE SUBSCRIPTION](sql-createsubscription.md)
- [CREATE TABLE](sql-createtable.md)
- [CREATE TABLE AS](sql-createtableas.md)
- [CREATE TABLESPACE](sql-createtablespace.md)
- [CREATE TEXT SEARCH CONFIGURATION](sql-createtsconfig.md)
- [CREATE TEXT SEARCH DICTIONARY](sql-createtsdictionary.md)
- [CREATE TEXT SEARCH PARSER](sql-createtsparser.md)
- [CREATE TEXT SEARCH TEMPLATE](sql-createtstemplate.md)
- [CREATE TRANSFORM](sql-createtransform.md)
- [CREATE TRIGGER](sql-createtrigger.md)
- [CREATE TYPE](sql-createtype.md)
- [CREATE USER](sql-createuser.md)
- [CREATE USER MAPPING](sql-createusermapping.md)
- [CREATE VIEW](sql-createview.md)
- [DEALLOCATE](sql-deallocate.md)
- [DECLARE](sql-declare.md)
- [DELETE](sql-delete.md)
- [DISCARD](sql-discard.md)
- [DO](sql-do.md)
- [DROP ACCESS METHOD](sql-drop-access-method.md)
- [DROP AGGREGATE](sql-dropaggregate.md)
- [DROP CAST](sql-dropcast.md)
- [DROP COLLATION](sql-dropcollation.md)
- [DROP CONVERSION](sql-dropconversion.md)
- [DROP DATABASE](sql-dropdatabase.md)
- [DROP DOMAIN](sql-dropdomain.md)
- [DROP EVENT TRIGGER](sql-dropeventtrigger.md)
- [DROP EXTENSION](sql-dropextension.md)
- [DROP FOREIGN DATA WRAPPER](sql-dropforeigndatawrapper.md)
- [DROP FOREIGN TABLE](sql-dropforeigntable.md)
- [DROP FUNCTION](sql-dropfunction.md)
- [DROP GROUP](sql-dropgroup.md)
- [DROP INDEX](sql-dropindex.md)
- [DROP LANGUAGE](sql-droplanguage.md)
- [DROP MATERIALIZED VIEW](sql-dropmaterializedview.md)
- [DROP OPERATOR](sql-dropoperator.md)
- [DROP OPERATOR CLASS](sql-dropopclass.md)
- [DROP OPERATOR FAMILY](sql-dropopfamily.md)
- [DROP OWNED](sql-drop-owned.md)
- [DROP POLICY](sql-droppolicy.md)
- [DROP PROCEDURE](sql-dropprocedure.md)
- [DROP PROPERTY GRAPH](sql-drop-property-graph.md)
- [DROP PUBLICATION](sql-droppublication.md)
- [DROP ROLE](sql-droprole.md)
- [DROP ROUTINE](sql-droproutine.md)
- [DROP RULE](sql-droprule.md)
- [DROP SCHEMA](sql-dropschema.md)
- [DROP SEQUENCE](sql-dropsequence.md)
- [DROP SERVER](sql-dropserver.md)
- [DROP STATISTICS](sql-dropstatistics.md)
- [DROP SUBSCRIPTION](sql-dropsubscription.md)
- [DROP TABLE](sql-droptable.md)
- [DROP TABLESPACE](sql-droptablespace.md)
- [DROP TEXT SEARCH CONFIGURATION](sql-droptsconfig.md)
- [DROP TEXT SEARCH DICTIONARY](sql-droptsdictionary.md)
- [DROP TEXT SEARCH PARSER](sql-droptsparser.md)
- [DROP TEXT SEARCH TEMPLATE](sql-droptstemplate.md)
- [DROP TRANSFORM](sql-droptransform.md)
- [DROP TRIGGER](sql-droptrigger.md)
- [DROP TYPE](sql-droptype.md)
- [DROP USER](sql-dropuser.md)
- [DROP USER MAPPING](sql-dropusermapping.md)
- [DROP VIEW](sql-dropview.md)
- [END](sql-end.md)
- [EXECUTE](sql-execute.md)
- [EXPLAIN](sql-explain.md)
- [FETCH](sql-fetch.md)
- [GRANT](sql-grant.md)
- [IMPORT FOREIGN SCHEMA](sql-importforeignschema.md)
- [INSERT](sql-insert.md)
- [LISTEN](sql-listen.md)
- [LOAD](sql-load.md)
- [LOCK](sql-lock.md)
- [MERGE](sql-merge.md)
- [MOVE](sql-move.md)
- [NOTIFY](sql-notify.md)
- [PREPARE](sql-prepare.md)
- [PREPARE TRANSACTION](sql-prepare-transaction.md)
- [REASSIGN OWNED](sql-reassign-owned.md)
- [REFRESH MATERIALIZED VIEW](sql-refreshmaterializedview.md)
- [REINDEX](sql-reindex.md)
- [RELEASE SAVEPOINT](sql-release-savepoint.md)
- [REPACK](sql-repack.md)
- [RESET](sql-reset.md)
- [REVOKE](sql-revoke.md)
- [ROLLBACK](sql-rollback.md)
- [ROLLBACK PREPARED](sql-rollback-prepared.md)
- [ROLLBACK TO SAVEPOINT](sql-rollback-to.md)
- [SAVEPOINT](sql-savepoint.md)
- [SECURITY LABEL](sql-security-label.md)
- [SELECT](sql-select.md)
- [SELECT INTO](sql-selectinto.md)
- [SET](sql-set.md)
- [SET CONSTRAINTS](sql-set-constraints.md)
- [SET ROLE](sql-set-role.md)
- [SET SESSION AUTHORIZATION](sql-set-session-authorization.md)
- [SET TRANSACTION](sql-set-transaction.md)
- [SHOW](sql-show.md)
- [START TRANSACTION](sql-start-transaction.md)
- [TRUNCATE](sql-truncate.md)
- [UNLISTEN](sql-unlisten.md)
- [UPDATE](sql-update.md)
- [VACUUM](sql-vacuum.md)
- [VALUES](sql-values.md)
- [WAIT FOR](sql-wait-for.md)