SQL Commands

NOTE: this part of help system is copied from PostgreSQL 7.3.1 documentation to provide you quick reference to SQL commands descriptions only. Please see PostgreSQL documentation for details.

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

This file was copied from PostgreSQL 7.3.1 help system.