SQL Commands

I. SQL Commands

This 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 --  abort the current transaction
ALTER DATABASE -- change a database
ALTER GROUP --  add users to a group or remove users from a group
ALTER TABLE --  change the definition of a table
ALTER TRIGGER --  change the definition of a trigger
ALTER USER -- change a database user account
ANALYZE --  collect statistics about a database
BEGIN --  start a transaction block
CHECKPOINT -- force a transaction log checkpoint
CLOSE --  close a cursor
CLUSTER --  cluster a table according to an index
COMMENT --  define or change the comment of an object
COMMIT --  commit the current transaction
COPY --  copy data between files and tables
CREATE AGGREGATE --  define a new aggregate function
CREATE CAST -- define a user-defined cast
CREATE CONSTRAINT TRIGGER --  define a new constraint trigger
CREATE CONVERSION -- define a user-defined conversion
CREATE DATABASE --  create a new database
CREATE DOMAIN --  define a new domain
CREATE FUNCTION -- define a new function
CREATE GROUP --  define a new user group
CREATE INDEX --  define a new index
CREATE LANGUAGE -- define a new procedural language
CREATE OPERATOR --  define a new operator
CREATE OPERATOR CLASS --  define a new operator class for indexes
CREATE RULE --  define a new rewrite rule
CREATE SCHEMA --  define a new schema
CREATE SEQUENCE --  define a new sequence generator
CREATE TABLE -- define a new table
CREATE TABLE AS -- create a new table from the results of a query
CREATE TRIGGER --  define a new trigger
CREATE TYPE --  define a new data type
CREATE USER -- define a new database user account
CREATE VIEW --  define a new view
DEALLOCATE --  remove a prepared query
DECLARE --  define a cursor
DELETE --  delete rows of a table
DROP AGGREGATE --  remove a user-defined aggregate function
DROP CAST -- remove a user-defined cast
DROP CONVERSION -- remove a user-defined conversion
DROP DATABASE --  remove a database
DROP DOMAIN --  remove a user-defined domain
DROP FUNCTION --  remove a user-defined function
DROP GROUP --  remove a user group
DROP INDEX --  remove an index
DROP LANGUAGE --  remove a user-defined procedural language
DROP OPERATOR --  remove a user-defined operator
DROP OPERATOR CLASS --  remove a user-defined operator class
DROP RULE --  remove a rewrite rule
DROP SCHEMA --  remove a schema
DROP SEQUENCE --  remove a sequence
DROP TABLE --  remove a table
DROP TRIGGER --  remove a trigger
DROP TYPE --  remove a user-defined data type
DROP USER -- remove a database user account
DROP VIEW --  remove a view
END --  commit the current transaction
EXECUTE --  execute a prepared query
EXPLAIN --  show the execution plan of a statement
FETCH --  retrieve rows from a table using a cursor
GRANT -- define access privileges
INSERT --  create new rows in a table
LISTEN --  listen for a notification
LOAD -- load or reload a shared library file
LOCK --  explicitly lock a table
MOVE --  position a cursor on a specified row of a table
NOTIFY --  generate a notification
PREPARE --  create a prepared query
REINDEX --  rebuild corrupted indexes
RESET -- restore the value of a run-time parameter to a default value
REVOKE -- remove access privileges
ROLLBACK --  abort the current transaction
SELECT --  retrieve rows from a table or view
SELECT INTO --  create a new table from the results of a query
SET -- change a run-time parameter
SET CONSTRAINTS -- set the constraint mode of the current transaction
SET SESSION AUTHORIZATION -- set the session user identifier and the current user identifier of the current session
SET TRANSACTION -- set the characteristics of the current transaction
SHOW -- show the value of a run-time parameter
START TRANSACTION -- start a transaction block
TRUNCATE --  empty a table
UNLISTEN --  stop listening for a notification
UPDATE --  update rows of a table
VACUUM --  garbage-collect and optionally analyze a database
© Copyright 2003-2023 www.php-editors.com. The ultimate PHP Editor and PHP IDE site.