ABORT
Terminates the current transaction.
See ABORT for more information.
ALTER AGGREGATE
Changes the definition of an aggregate function
See ALTER AGGREGATE for more information.
ALTER COLLATION
Changes the definition of a collation.
See ALTER COLLATION for more information.
ALTER CONVERSION
Changes the definition of a conversion.
See ALTER CONVERSION for more information.
ALTER DATABASE
Changes the attributes of a database.
See ALTER DATABASE for more information.
ALTER DEFAULT PRIVILEGES
Changes default access privileges.
See ALTER DEFAULT PRIVILEGES for more information.
ALTER DOMAIN
Changes the definition of a domain.
See ALTER DOMAIN for more information.
ALTER EXTENSION
Change the definition of an extension that is registered in a Greenplum database.
See ALTER EXTENSION for more information.
ALTER EXTERNAL TABLE
Changes the definition of an external table.
where action is one of:
See ALTER EXTERNAL TABLE for more information.
ALTER FOREIGN DATA WRAPPER
Changes the definition of a foreign-data wrapper.
See ALTER FOREIGN DATA WRAPPER for more information.
ALTER FOREIGN TABLE
Changes the definition of a foreign table.
See ALTER FOREIGN TABLE for more information.
ALTER FUNCTION
Changes the definition of a function.
See ALTER FUNCTION for more information.
ALTER GROUP
Changes a role name or membership.
See ALTER GROUP for more information.
ALTER INDEX
Changes the definition of an index.
See ALTER INDEX for more information.
ALTER LANGUAGE
Changes the name of a procedural language.
See ALTER LANGUAGE for more information.
ALTER MATERIALIZED VIEW
Changes the definition of a materialized view.
See ALTER MATERIALIZED VIEW for more information.
ALTER OPERATOR
Changes the definition of an operator.
See ALTER OPERATOR for more information.
ALTER OPERATOR CLASS
Changes the definition of an operator class.
See ALTER OPERATOR CLASS for more information.
ALTER OPERATOR FAMILY
Changes the definition of an operator family.
See ALTER OPERATOR FAMILY for more information.
ALTER PROTOCOL
Changes the definition of a protocol.
See ALTER PROTOCOL for more information.
ALTER RESOURCE GROUP
Changes the limits of a resource group.
See ALTER RESOURCE GROUP for more information.
ALTER RESOURCE QUEUE
Changes the limits of a resource queue.
See ALTER RESOURCE QUEUE for more information.
ALTER ROLE
Changes a database role (user or group).
See ALTER ROLE for more information.
ALTER RULE
Changes the definition of a rule.
See ALTER RULE for more information.
ALTER SCHEMA
Changes the definition of a schema.
See ALTER SCHEMA for more information.
ALTER SEQUENCE
Changes the definition of a sequence generator.
See ALTER SEQUENCE for more information.
ALTER SERVER
Changes the definition of a foreign server.
See ALTER SERVER for more information.
ALTER TABLE
Changes the definition of a table.
See ALTER TABLE for more information.
ALTER TABLESPACE
Changes the definition of a tablespace.
See ALTER TABLESPACE for more information.
ALTER TEXT SEARCH CONFIGURATION
Changes the definition of a text search configuration.
See ALTER TEXT SEARCH CONFIGURATION for more information.
ALTER TEXT SEARCH DICTIONARY
Changes the definition of a text search dictionary.
See ALTER TEXT SEARCH DICTIONARY for more information.
ALTER TEXT SEARCH PARSER
Changes the definition of a text search parser.
See ALTER TEXT SEARCH PARSER for more information.
ALTER TEXT SEARCH TEMPLATE
Changes the definition of a text search template.
See ALTER TEXT SEARCH TEMPLATE for more information.
ALTER TYPE
Changes the definition of a data type.
See ALTER TYPE for more information.
ALTER USER
Changes the definition of a database role (user).
See ALTER USER for more information.
ALTER USER MAPPING
Changes the definition of a user mapping for a foreign server.
See ALTER USER MAPPING for more information.
ALTER VIEW
Changes properties of a view.
See ALTER VIEW for more information.
ANALYZE
Collects statistics about a database.
See ANALYZE for more information.
BEGIN
Starts a transaction block.
See BEGIN for more information.
CHECKPOINT
Forces a transaction log checkpoint.
See CHECKPOINT for more information.
CLOSE
Closes a cursor.
See CLOSE for more information.
CLUSTER
Physically reorders a heap storage table on disk according to an index. Not a recommended operation in Greenplum Database.
See CLUSTER for more information.
COMMENT
Defines or changes the comment of an object.
See COMMENT for more information.
COMMIT
Commits the current transaction.
See COMMIT for more information.
COPY
Copies data between a file and a table.
See COPY for more information.
CREATE AGGREGATE
Defines a new aggregate function.
See CREATE AGGREGATE for more information.
CREATE CAST
Defines a new cast.
See CREATE CAST for more information.
CREATE COLLATION
Defines a new collation using the specified operating system locale settings, or by copying an existing collation.
See CREATE COLLATION for more information.
CREATE CONVERSION
Defines a new encoding conversion.
See CREATE CONVERSION for more information.
CREATE DATABASE
Creates a new database.
See CREATE DATABASE for more information.
CREATE DOMAIN
Defines a new domain.
See CREATE DOMAIN for more information.
CREATE EXTENSION
Registers an extension in a Greenplum database.
See CREATE EXTENSION for more information.
CREATE EXTERNAL TABLE
Defines a new external table.
See CREATE EXTERNAL TABLE for more information.
CREATE FOREIGN DATA WRAPPER
Defines a new foreign-data wrapper.
See CREATE FOREIGN DATA WRAPPER for more information.
CREATE FOREIGN TABLE
Defines a new foreign table.
See CREATE FOREIGN TABLE for more information.
CREATE FUNCTION
Defines a new function.
See CREATE FUNCTION for more information.
CREATE GROUP
Defines a new database role.
See CREATE GROUP for more information.
CREATE INDEX
Defines a new index.
See CREATE INDEX for more information.
CREATE LANGUAGE
Defines a new procedural language.
See CREATE LANGUAGE for more information.
CREATE MATERIALIZED VIEW
Defines a new materialized view.
See CREATE MATERIALIZED VIEW for more information.
CREATE OPERATOR
Defines a new operator.
See CREATE OPERATOR for more information.
CREATE OPERATOR CLASS
Defines a new operator class.
See CREATE OPERATOR CLASS for more information.
CREATE OPERATOR FAMILY
Defines a new operator family.
See CREATE OPERATOR FAMILY for more information.
CREATE PROTOCOL
Registers a custom data access protocol that can be specified when defining a Greenplum Database external table.
See CREATE PROTOCOL for more information.
CREATE RESOURCE GROUP
Defines a new resource group.
See CREATE RESOURCE GROUP for more information.
CREATE RESOURCE QUEUE
Defines a new resource queue.
See CREATE RESOURCE QUEUE for more information.
CREATE ROLE
Defines a new database role (user or group).
See CREATE ROLE for more information.
CREATE RULE
Defines a new rewrite rule.
See CREATE RULE for more information.
CREATE SCHEMA
Defines a new schema.
See CREATE SCHEMA for more information.
CREATE SEQUENCE
Defines a new sequence generator.
See CREATE SEQUENCE for more information.
CREATE SERVER
Defines a new foreign server.
See CREATE SERVER for more information.
CREATE TABLE
Defines a new table.
See CREATE TABLE for more information.
CREATE TABLE AS
Defines a new table from the results of a query.
See CREATE TABLE AS for more information.
CREATE TABLESPACE
Defines a new tablespace.
See CREATE TABLESPACE for more information.
CREATE TEXT SEARCH CONFIGURATION
Defines a new text search configuration.
See CREATE TEXT SEARCH CONFIGURATION for more information.
CREATE TEXT SEARCH DICTIONARY
Defines a new text search dictionary.
See CREATE TEXT SEARCH DICTIONARY for more information.
CREATE TEXT SEARCH PARSER
Defines a new text search parser.
See CREATE TEXT SEARCH PARSER for more information.
CREATE TEXT SEARCH TEMPLATE
Defines a new text search template.
See CREATE TEXT SEARCH TEMPLATE for more information.
CREATE TYPE
Defines a new data type.
See CREATE TYPE for more information.
CREATE USER
Defines a new database role with the LOGIN
privilege by default.
See CREATE USER for more information.
CREATE USER MAPPING
Defines a new mapping of a user to a foreign server.
See CREATE USER MAPPING for more information.
CREATE VIEW
Defines a new view.
See CREATE VIEW for more information.
DEALLOCATE
Deallocates a prepared statement.
See DEALLOCATE for more information.
DECLARE
Defines a cursor.
See DECLARE for more information.
DELETE
Deletes rows from a table.
See DELETE for more information.
DISCARD
Discards the session state.
See DISCARD for more information.
DROP AGGREGATE
Removes an aggregate function.
See DROP AGGREGATE for more information.
DO
Runs anonymous code block as a transient anonymous function.
See DO for more information.
DROP CAST
Removes a cast.
See DROP CAST for more information.
DROP COLLATION
Removes a previously defined collation.
See DROP COLLATION for more information.
DROP CONVERSION
Removes a conversion.
See DROP CONVERSION for more information.
DROP DATABASE
Removes a database.
See DROP DATABASE for more information.
DROP DOMAIN
Removes a domain.
See DROP DOMAIN for more information.
DROP EXTENSION
Removes an extension from a Greenplum database.
See DROP EXTENSION for more information.
DROP EXTERNAL TABLE
Removes an external table definition.
See DROP EXTERNAL TABLE for more information.
DROP FOREIGN DATA WRAPPER
Removes a foreign-data wrapper.
See DROP FOREIGN DATA WRAPPER for more information.
DROP FOREIGN TABLE
Removes a foreign table.
See DROP FOREIGN TABLE for more information.
DROP FUNCTION
Removes a function.
See DROP FUNCTION for more information.
DROP GROUP
Removes a database role.
See DROP GROUP for more information.
DROP INDEX
Removes an index.
See DROP INDEX for more information.
DROP LANGUAGE
Removes a procedural language.
See DROP LANGUAGE for more information.
DROP MATERIALIZED VIEW
Removes a materialized view.
See DROP MATERIALIZED VIEW for more information.
DROP OPERATOR
Removes an operator.
See DROP OPERATOR for more information.
DROP OPERATOR CLASS
Removes an operator class.
See DROP OPERATOR CLASS for more information.
DROP OPERATOR FAMILY
Removes an operator family.
See DROP OPERATOR FAMILY for more information.
DROP OWNED
Removes database objects owned by a database role.
See DROP OWNED for more information.
DROP PROTOCOL
Removes a external table data access protocol from a database.
See DROP PROTOCOL for more information.
DROP RESOURCE GROUP
Removes a resource group.
See DROP RESOURCE GROUP for more information.
DROP RESOURCE QUEUE
Removes a resource queue.
See DROP RESOURCE QUEUE for more information.
DROP ROLE
Removes a database role.
See DROP ROLE for more information.
DROP RULE
Removes a rewrite rule.
See DROP RULE for more information.
DROP SCHEMA
Removes a schema.
See DROP SCHEMA for more information.
DROP SEQUENCE
Removes a sequence.
See DROP SEQUENCE for more information.
DROP SERVER
Removes a foreign server descriptor.
See DROP SERVER for more information.
DROP TABLE
Removes a table.
See DROP TABLE for more information.
DROP TABLESPACE
Removes a tablespace.
See DROP TABLESPACE for more information.
DROP TEXT SEARCH CONFIGURATION
Removes a text search configuration.
See DROP TEXT SEARCH CONFIGURATION for more information.
DROP TEXT SEARCH DICTIONARY
Removes a text search dictionary.
See DROP TEXT SEARCH DICTIONARY for more information.
DROP TEXT SEARCH PARSER
Remove a text search parser.
See DROP TEXT SEARCH PARSER for more information.
DROP TEXT SEARCH TEMPLATE
Removes a text search template.
See DROP TEXT SEARCH TEMPLATE for more information.
DROP TYPE
Removes a data type.
See DROP TYPE for more information.
DROP USER
Removes a database role.
See DROP USER for more information.
DROP USER MAPPING
Removes a user mapping for a foreign server.
See DROP USER MAPPING for more information.
DROP VIEW
Removes a view.
See DROP VIEW for more information.
END
Commits the current transaction.
See END for more information.
EXECUTE
Runs a prepared SQL statement.
See EXECUTE for more information.
EXPLAIN
Shows the query plan of a statement.
See EXPLAIN for more information.
FETCH
Retrieves rows from a query using a cursor.
See FETCH for more information.
GRANT
Defines access privileges.
See GRANT for more information.
INSERT
Creates new rows in a table.
See INSERT for more information.
LOAD
Loads or reloads a shared library file.
See LOAD for more information.
LOCK
Locks a table.
See LOCK for more information.
MOVE
Positions a cursor.
See MOVE for more information.
PREPARE
Prepare a statement for execution.
See PREPARE for more information.
REASSIGN OWNED
Changes the ownership of database objects owned by a database role.
See REASSIGN OWNED for more information.
REFRESH MATERIALIZED VIEW
Replaces the contents of a materialized view.
See REFRESH MATERIALIZED VIEW for more information.
REINDEX
Rebuilds indexes.
See REINDEX for more information.
RELEASE SAVEPOINT
Destroys a previously defined savepoint.
See RELEASE SAVEPOINT for more information.
RESET
Restores the value of a system configuration parameter to the default value.
See RESET for more information.
RETRIEVE
Retrieves rows from a query using a parallel retrieve cursor.
See RETRIEVE for more information.
REVOKE
Removes access privileges.
See REVOKE for more information.
ROLLBACK
Stops the current transaction.
See ROLLBACK for more information.
ROLLBACK TO SAVEPOINT
Rolls back the current transaction to a savepoint.
See ROLLBACK TO SAVEPOINT for more information.
SAVEPOINT
Defines a new savepoint within the current transaction.
See SAVEPOINT for more information.
SELECT
Retrieves rows from a table or view.
See SELECT for more information.
SELECT INTO
Defines a new table from the results of a query.
See SELECT INTO for more information.
SET
Changes the value of a Greenplum Database configuration parameter.
See SET for more information.
SET CONSTRAINTS
Sets constraint check timing for the current transaction.
See SET CONSTRAINTS for more information.
SET ROLE
Sets the current role identifier of the current session.
See SET ROLE for more information.
SET SESSION AUTHORIZATION
Sets the session role identifier and the current role identifier of the current session.
See SET SESSION AUTHORIZATION for more information.
SET TRANSACTION
Sets the characteristics of the current transaction.
See SET TRANSACTION for more information.
SHOW
Shows the value of a system configuration parameter.
See SHOW for more information.
START TRANSACTION
Starts a transaction block.
See START TRANSACTION for more information.
TRUNCATE
Empties a table of all rows.
See TRUNCATE for more information.
UPDATE
Updates rows of a table.
See UPDATE for more information.
VACUUM
Garbage-collects and optionally analyzes a database.
See VACUUM for more information.
VALUES
Computes a set of rows.
See VALUES for more information.
Parent topic: SQL Commands
Content feedback and comments