Wiki / SQL Commands
SQL Commands
Compare versionsSyntax, examples, and the evolution of every PostgreSQL SQL command.
Reading PG 18current·30 versions documented, 6.4 to 20
-
close a cursor
-
deallocate a prepared statement
-
define a cursor
-
execute a prepared statement
-
retrieve rows from a query using a cursor
-
position a cursor
-
prepare a statement for execution
-
change a database
-
change the definition of a schema
-
change the definition of a tablespace
-
create a new database
-
define a new schema
-
define a new tablespace
-
remove a database
-
remove a schema
-
remove a tablespace
-
change the definition of an extension
-
define a new access method
-
install an extension
-
remove an access method
-
remove an extension
-
load a shared library file
-
change the definition of a foreign-data wrapper
-
change the definition of a foreign table
-
change the definition of a foreign server
-
change the definition of a user mapping
-
define a new foreign-data wrapper
-
define a new foreign table
-
define a new foreign server
-
define a new mapping of a user to a foreign server
-
remove a foreign-data wrapper
-
remove a foreign table
-
remove a foreign server descriptor
-
remove a user mapping for a foreign server
-
import table definitions from a foreign server
-
change the definition of an aggregate function
-
change the definition of a function
-
change the definition of a procedural language
-
change the definition of a procedure
-
change the definition of a routine
-
invoke a procedure
-
define a new aggregate function
-
define a new function
-
define a new procedural language
-
define a new procedure
-
define a new transform
-
execute an anonymous code block
-
remove an aggregate function
-
remove a function
-
remove a procedural language
-
remove a procedure
-
remove a routine
-
remove a transform
-
change the definition of an index
-
change the definition of an extended statistics object
-
define a new index
-
define extended statistics
-
remove an index
-
remove extended statistics
-
rebuild indexes
-
change the definition of a publication
-
change the definition of a subscription
-
define a new publication
-
define a new subscription
-
remove a publication
-
remove a subscription
-
collect statistics about a database
-
force a write-ahead log checkpoint
-
cluster a table according to an index
-
garbage-collect and optionally analyze a database
-
change the definition of a large object
-
define or change the comment of an object
-
rewrite a table to reclaim disk space
-
copy data between a file and a table
-
delete rows of a table
-
show the execution plan of a statement
-
create new rows in a table
-
lock a table
-
conditionally insert, update, or delete rows of a table
-
retrieve rows from a table or view
-
define a new table from the results of a query
-
update rows of a table
-
compute a set of rows
-
define default access privileges
-
change role name or membership
-
change the definition of a row-level security policy
-
change a database role
-
change a database role
-
define a new database role
-
define a new row-level security policy for a table
-
define a new database role
-
define a new database role
-
remove a database role
-
remove database objects owned by a database role
-
remove a row-level security policy from a table
-
remove a database role
-
remove a database role
-
define access privileges
-
change the ownership of database objects owned by a database role
-
remove access privileges
-
define or change a security label applied to an object
-
set the current user identifier of the current session
-
set the session user identifier and the current user identifier of the current session
-
change a server configuration parameter
-
discard session state
-
listen for a notification
-
generate a notification
-
restore the value of a run-time parameter to the default value
-
change a run-time parameter
-
show the value of a run-time parameter
-
stop listening for a notification
-
change the definition of a materialized view
-
change the definition of a sequence generator
-
change the definition of a table
-
change the definition of a view
-
define a new materialized view
-
define a new sequence generator
-
define a new table
-
define a new table from the results of a query
-
define a new view
-
remove a materialized view
-
remove a sequence
-
remove a table
-
remove a view
-
replace the contents of a materialized view
-
empty a table or set of tables
-
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
-
define a new text search configuration
-
define a new text search dictionary
-
define a new text search parser
-
define a new text search template
-
remove a text search configuration
-
remove a text search dictionary
-
remove a text search parser
-
remove a text search template
-
abort the current transaction
-
start a transaction block
-
Begins a transaction
-
commit the current transaction
-
commit a transaction that was earlier prepared for two-phase commit
-
commit the current transaction
-
prepare the current transaction for two-phase commit
-
release a previously defined savepoint
-
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
-
set constraint check timing for the current transaction
-
set the characteristics of the current transaction
-
start a transaction block
-
wait for WAL to reach a target LSN
-
change the definition of an event trigger
-
change the definition of a rule
-
change the definition of a trigger
-
define a new constraint trigger
-
define a new event trigger
-
define a new rewrite rule
-
define a new trigger
-
remove an event trigger
-
remove a rewrite rule
-
remove a trigger
-
change the definition of a collation
-
change the definition of a conversion
-
change the definition of a domain
-
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 type
-
define a new cast
-
define a new collation
-
define a new encoding conversion
-
define a new domain
-
define a new operator
-
define a new operator class
-
define a new operator family
-
define a new data type
-
remove a cast
-
remove a collation
-
remove a conversion
-
remove a domain
-
remove an operator
-
remove an operator class
-
remove an operator family
-
remove a data type