PrevFast BackwardFast ForwardNext

I. SQL Commands

This part contains reference information for the SQL commands supported by EnterpriseDB. 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
ALTER DATABASE -- change a database
ALTER FUNCTION -- change the definition of a function
ALTER GROUP -- change a user group
ALTER INDEX -- change the definition of an index
ALTER OPERATOR -- change the definition of an operator
ALTER SCHEMA -- change the definition of a schema
ALTER SEQUENCE --  change the definition of a sequence generator
ALTER TABLE -- change the definition of a table
ALTER TABLESPACE -- change the definition of a tablespace
ALTER TRIGGER -- change the definition of a trigger
ALTER TYPE --  change the definition of a type
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 a file and a table
CREATE DATABASE -- create a new database
CREATE FUNCTION -- define a new function
CREATE GROUP -- define a new user group
CREATE INDEX -- define a new index
CREATE OPERATOR -- define a new operator
CREATE PROCEDURE -- create a new procedure
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 -- define a new table from the results of a query
CREATE TABLESPACE -- define a new tablespace
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
DECLARE -- define a cursor
DELETE -- delete rows of a table
DROP DATABASE -- remove a database
DROP FUNCTION -- remove a function
DROP GROUP -- remove a user group
DROP INDEX -- remove an index
DROP OPERATOR -- remove an operator
DROP PROCEDURE -- drop a stored procedure
DROP RULE -- remove a rewrite rule
DROP SCHEMA -- remove a schema
DROP SEQUENCE -- remove a sequence
DROP TABLE -- remove a table
DROP TABLESPACE -- remove a tablespace
DROP TRIGGER -- remove a trigger
DROP TYPE -- remove a data type
DROP USER -- remove a database user account
DROP VIEW -- remove a view
END -- commit the current transaction
EXPLAIN -- show the execution plan of a statement
FETCH -- retrieve rows from a query using a cursor
GRANT -- define access privileges
INSERT -- create new rows in a table
LOCK -- lock a table
PREPARE -- prepare a statement for execution
REINDEX -- rebuild indexes
RELEASE SAVEPOINT -- destroy a previously defined savepoint
REVOKE -- remove access privileges
ROLLBACK -- abort the current transaction
ROLLBACK TO SAVEPOINT -- roll back to a savepoint
SAVEPOINT -- define a new savepoint within the current transaction
SELECT -- retrieve rows from a table or view
SELECT INTO -- define a new table from the results of a query
SET -- change a run-time parameter
SET CONSTRAINTS -- set constraint checking modes for 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
START TRANSACTION -- start a transaction block
TRUNCATE -- empty a table
UPDATE -- update rows of a table
UPDATE RETURNING -- update rows of a table and return the updated rows
VACUUM -- garbage-collect and optionally analyze a database
PrevHomeNext
ReferenceUpALTER DATABASE