SQL Commands
Version coverage matrixDefinitions for PostgreSQL 18
English manual coverage begins with PostgreSQL 6.4. Source history and runtime observations have their own recorded version boundaries.
Reading PG 18·Select a recorded version
abort the current transaction
change the definition of an aggregate function
change the definition of a collation
change the definition of a conversion
change a database
define default access privileges
change the definition of a domain
change the definition of an event trigger
change the definition of an extension
change the definition of a foreign-data wrapper
change the definition of a foreign table
change the definition of a function
change role name or membership
change the definition of an index
change the definition of a procedural language
change the definition of a large object
change the definition of a materialized view
change the definition of an operator
change the definition of an operator class
change the definition of an operator family
change the definition of a row-level security policy
change the definition of a procedure
change the definition of a publication
change a database role
change the definition of a routine
change the definition of a rule
change the definition of a schema
change the definition of a sequence generator
change the definition of a foreign server
change the definition of an extended statistics object
change the definition of a subscription
change a server configuration parameter
change the definition of a table
change the definition of a tablespace
change the definition of a text search configuration
change the definition of a text search dictionary
change the definition of a text search parser
change the definition of a text search template
change the definition of a trigger
change the definition of a type
change a database role
change the definition of a user mapping
change the definition of a view
collect statistics about a database
start a transaction block
invoke a procedure
force a write-ahead log checkpoint
close a cursor
cluster a table according to an index
define or change the comment of an object
commit the current transaction
commit a transaction that was earlier prepared for two-phase commit
copy data between a file and a table
define a new access method
define a new aggregate function
define a new cast
define a new collation
define a new encoding conversion
create a new database
define a new domain
define a new event trigger
install an extension
define a new foreign-data wrapper
define a new foreign table
define a new function
define a new database role
define a new index
define a new procedural language
define a new materialized view
define a new operator
define a new operator class
define a new operator family
define a new row-level security policy for a table
define a new procedure
define a new publication
define a new database role
define a new rewrite rule
define a new schema
define a new sequence generator
define a new foreign server
define extended statistics
define a new subscription
define a new table
define a new table from the results of a query
define a new tablespace
define a new text search configuration
define a new text search dictionary
define a new text search parser
define a new text search template
define a new transform
define a new trigger
define a new data type
define a new database role
define a new mapping of a user to a foreign server
define a new view
deallocate a prepared statement
define a cursor
delete rows of a table
discard session state
execute an anonymous code block
remove an access method
remove an aggregate function
remove a cast
remove a collation
remove a conversion
remove a database
remove a domain
remove an event trigger
remove an extension
remove a foreign-data wrapper
remove a foreign table
remove a function
remove a database role
remove an index
remove a procedural language
remove a materialized view
remove an operator
remove an operator class
remove an operator family
remove database objects owned by a database role
remove a row-level security policy from a table
remove a procedure
remove a publication
remove a database role
remove a routine
remove a rewrite rule
remove a schema
remove a sequence
remove a foreign server descriptor
remove extended statistics
remove a subscription
remove a table
remove a tablespace
remove a text search configuration
remove a text search dictionary
remove a text search parser
remove a text search template
remove a transform
remove a trigger
remove a data type
remove a database role
remove a user mapping for a foreign server
remove a view
commit the current transaction
execute a prepared statement
show the execution plan of a statement
retrieve rows from a query using a cursor
define access privileges
import table definitions from a foreign server
create new rows in a table
listen for a notification
load a shared library file
lock a table
conditionally insert, update, or delete rows of a table
position a cursor
generate a notification
prepare a statement for execution
prepare the current transaction for two-phase commit
change the ownership of database objects owned by a database role
replace the contents of a materialized view
rebuild indexes
release a previously defined savepoint
restore the value of a run-time parameter to the default value
remove access privileges
abort the current transaction
cancel a transaction that was earlier prepared for two-phase commit
roll back to a savepoint
define a new savepoint within the current transaction
define or change a security label applied to an object
retrieve rows from a table or view
define a new table from the results of a query
change a run-time parameter
set constraint check timing for the current transaction
set the current user identifier of the current session
set the session user identifier and the current user identifier of the current session
set the characteristics of the current transaction
show the value of a run-time parameter
start a transaction block
empty a table or set of tables
stop listening for a notification
update rows of a table
garbage-collect and optionally analyze a database
compute a set of rows