SQL Statements Index

Access Method

• CREATE ACCESS METHOD - Defines a new access method.
• DROP ACCESS METHOD - Removes an access method.

Cast

• CREATE CAST - Defines a new cast.
• DROP CAST - Removes a cast.

Collation

• CREATE COLLATION - Defines a new collation.
• ALTER COLLATION - Changes the definition of a collation.
• DROP COLLATION - Removes a previously defined collation.

Conversion

• CREATE CONVERSION - Defines a new encoding conversion.
• ALTER CONVERSION - Changes the definition of a conversion.
• DROP CONVERSION - Removes a conversion.

Cursor

• DECLARE - Defines a cursor.
• CLOSE - Closes a cursor.
• FETCH - Retrieves rows from a query using a cursor.
• MOVE - Positions a cursor.
• RETRIEVE - Retrieves rows from a query using a parallel retrieve cursor.

Database

• CREATE DATABASE - Creates a new database.
• ALTER DATABASE - Changes the attributes of a database.
• DROP DATABASE - Removes a database.
• ANALYZE - Collects statistics about a database.
• VACUUM - Garbage-collects and optionally analyzes a database.
• CHECKPOINT - Forces a write-ahead log checkpoint.
• COMMENT - Defines or changes the comment of an object.
• COPY - Copies data between a file and a table.
• LOAD - Loads or reloads a shared library file.

Domain

• CREATE DOMAIN - Defines a new domain.
• ALTER DOMAIN - Changes the definition of a domain.
• DROP DOMAIN - Removes a domain.

Extension

• CREATE EXTENSION - Registers an extension in a Cloudberry Database.
• ALTER EXTENSION - Change the definition of an extension.
• DROP EXTENSION - Removes an extension from a Cloudberry Database.

External Table

• CREATE EXTERNAL TABLE - Defines a new external table.
• ALTER EXTERNAL TABLE - Changes the definition of an external table.
• DROP EXTERNAL TABLE - Removes an external table definition.

Foreign Data Wrapper

• CREATE FOREIGN DATA WRAPPER - Defines a new foreign-data wrapper.
• ALTER FOREIGN DATA WRAPPER - Changes the definition of a foreign-data wrapper.
• DROP FOREIGN DATA WRAPPER - Removes a foreign-data wrapper.

Function & Aggregate Function

Function

• CREATE FUNCTION - Defines a new function.
• ALTER FUNCTION - Changes the definition of a function.
• DROP FUNCTION - Removes a function.

Aggregate Function

• CREATE AGGREGATE - Defines a new aggregate function.
• ALTER AGGREGATE - Changes the definition of an aggregate function.
• DROP AGGREGATE - Removes an aggregate function.

Foreign Table

• CREATE FOREIGN TABLE - Defines a new foreign table.
• ALTER FOREIGN TABLE - Changes the definition of a foreign table.
• DROP FOREIGN TABLE - Removes a foreign table.

User & Group

• CREATE ROLE - Defines a new database role (user or group).
• ALTER ROLE - Changes a database role (user or group).
• SET ROLE - Sets the current role identifier of the current session.
• DROP ROLE - Removes a database role.
• ALTER GROUP - Changes a role name or membership.
• CREATE USER - Defines a new database role.
• ALTER USER - Changes the definition of a database role.
• DROP USER - Removes a database role.
• DROP GROUP - Removes a database role.
• DROP OWNED - Removes database objects owned by a database role.
• REASSIGN OWNED - Changes the ownership of database objects owned by a database role.

Index

• CREATE INDEX - Defines a new index.
• ALTER INDEX - Changes the definition of an index.
• REINDEX - Rebuilds indexes.
• DROP INDEX - Removes an index.

Notification

• NOTIFY - Generates a notification.
• LISTEN - Listens for a notification.
• UNLISTEN - Stops listening for a notification.

Procedural Language

• CREATE LANGUAGE - Defines a new procedural language.
• ALTER LANGUAGE - Changes the definition of a procedural language.
• DROP LANGUAGE - Removes a procedural language.
• DO - Runs anonymous code block as a transient anonymous function.

View and Materialized View

• CREATE VIEW - Defines a new view.
• ALTER VIEW - Changes properties of a view.
• DROP VIEW - Removes a view.
• CREATE MATERIALIZED VIEW - Defines a new materialized view.
• ALTER MATERIALIZED VIEW - Changes the definition of a materialized view.
• DROP MATERIALIZED VIEW - Removes a materialized view.
• REFRESH MATERIALIZED VIEW - Replaces the contents of a materialized view.

Operator & Operator Class & Operator Family

Operator

• CREATE OPERATOR - Defines a new operator.
• ALTER OPERATOR - Changes the definition of an operator.
• DROP OPERATOR - Removes an operator.

Operator Class

• CREATE OPERATOR CLASS - Defines a new operator class.
• ALTER OPERATOR CLASS - Changes the definition of an operator class.
• DROP OPERATOR CLASS - Removes an operator class.

Operator Family

• CREATE OPERATOR FAMILY - Defines a new operator family.
• ALTER OPERATOR FAMILY - Changes the definition of an operator family.
• DROP OPERATOR FAMILY - Removes an operator family.

Privilege & Security

Privilege

• GRANT - Defines access privileges.
• ALTER DEFAULT PRIVILEGES - Changes default access privileges.
• REVOKE - Removes access privileges.

Row-level Security Policy

• CREATE POLICY - Defines a new row-level security policy for a table.
• ALTER POLICY - Changes the definition of a row-level security policy.
• DROP POLICY - Removes a row-level security policy from a table.

Procedure

• CREATE PROCEDURE - Defines a new procedure.
• ALTER PROCEDURE - Changes the definition of a procedure.
• DROP PROCEDURE - Removes a procedure.
• CALL - Invokes a procedure.

Protocol

• CREATE PROTOCOL - Registers a custom data access protocol that can be specified when defining a Cloudberry Database external table.
• ALTER PROTOCOL - Changes the definition of a protocol.
• DROP PROTOCOL - Removes a data access protocol from a database.

Resource Management

Resource Group

• CREATE RESOURCE GROUP - Defines a new resource group.
• ALTER RESOURCE GROUP - Changes the limits of a resource group.
• DROP RESOURCE GROUP - Removes a resource group.

Resource Queue

• CREATE RESOURCE QUEUE - Defines a new resource queue.
• ALTER RESOURCE QUEUE - Changes the limits of a resource queue.
• DROP RESOURCE QUEUE - Removes a resource queue.

Routine

• ALTER ROUTINE - Changes the definition of a routine.
• DROP ROUTINE - Removes a routine.

Rule

• CREATE RULE - Defines a new rewrite rule.
• ALTER RULE - Changes the definition of a rule.
• DROP RULE - Removes a rewrite rule.

Row

• INSERT - Creates new rows in a table.
• SELECT - Retrieves rows from a table or view.
• UPDATE - Updates rows of a table.
• VALUES - Computes a set of rows.

Schema

• CREATE SCHEMA - Defines a new schema.
• ALTER SCHEMA - Changes the definition of a schema.
• DROP SCHEMA - Removes a schema.

Sequence

• CREATE SEQUENCE - Defines a new sequence generator.
• ALTER SEQUENCE - Changes the definition of a sequence generator.
• DROP SEQUENCE - Removes a sequence.

Session

• SET SESSION AUTHORIZATION - Sets the session role identifier and the current role identifier of the current session.
• DISCARD - Discards the session state.

Foreign Server

• CREATE SERVER - Defines a new foreign server.
• ALTER SERVER - Changes the definition of a foreign server.
• DROP SERVER - Removes a foreign server descriptor.
• CREATE USER MAPPING - Defines a new mapping of a user to a foreign server.
• ALTER USER MAPPING - Changes the definition of a user mapping for a foreign server.
• DROP USER MAPPING - Removes a user mapping for a foreign server.

Statistics Object

• CREATE STATISTICS - Defines extended statistics.
• ALTER STATISTICS - Changes the definition of an extended statistics object.
• DROP STATISTICS - Removes extended statistics.

Table

• CREATE TABLE - Defines a new table.
• ALTER TABLE - Changes the definition of a table.
• DROP TABLE - Removes a table.
• CLUSTER - Physically reorders a table on disk according to an index.
• CREATE TABLE AS - Defines a new table from the results of a query.
• DELETE - Deletes rows from a table
• TRUNCATE - Empties a table or set of tables of all rows.
• IMPORT FOREIGN SCHEMA - Imports table definitions from a foreign server.
• SELECT INTO - Defines a new table from the results of a query.

Tablespace

• CREATE TABLESPACE - Defines a new tablespace.
• ALTER TABLESPACE - Changes the definition of a tablespace.
• DROP TABLESPACE - Removes a tablespace.

Text Search

Text Search Configuration

• CREATE TEXT SEARCH CONFIGURATION - Defines a new text search configuration.
• ALTER TEXT SEARCH CONFIGURATION - Changes the definition of a text search configuration.
• DROP TEXT SEARCH CONFIGURATION - Removes a text search configuration.

Text Search Dictionary

• CREATE TEXT SEARCH DICTIONARY - Defines a new text search dictionary.
• ALTER TEXT SEARCH DICTIONARY - Changes the definition of a text search dictionary.
• DROP TEXT SEARCH DICTIONARY - Removes a text search dictionary.

Text Search Parser

• CREATE TEXT SEARCH PARSER - Defines a new text search parser.
• ALTER TEXT SEARCH PARSER - Changes the definition of a text search parser.
• DROP TEXT SEARCH PARSER - Removes a text search parser.

Text Search Template

• CREATE TEXT SEARCH TEMPLATE - Defines a new text search template.
• ALTER TEXT SEARCH TEMPLATE - Changes the definition of a text search template.
• DROP TEXT SEARCH TEMPLATE - Removes a text search template.

Transform

• CREATE TRANSFORM - Defines a new transform.
• DROP TRANSFORM - Removes a transform.

Trigger

• CREATE TRIGGER - Defines a new trigger.
• ALTER TRIGGER - Changes the definition of a trigger.
• DROP TRIGGER - Removes a trigger.

Data Type

• CREATE TYPE - Defines a new data type.
• ALTER TYPE - Changes the definition of a data type.
• DROP TYPE - Removes a data type.

Transaction

• BEGIN - Starts a transaction block.
• ABORT - Terminates the current transaction.
• COMMIT - Commits the current transaction.
• END - Commits the current transaction.
• ROLLBACK - Stops the current transaction.
• START TRANSACTION - Starts a transaction block.
• SET TRANSACTION - Sets the characteristics of the current transaction.
• SAVEPOINT - Defines a new savepoint within the current transaction.
• RELEASE SAVEPOINT - Destroys a previously defined savepoint.
• ROLLBACK TO SAVEPOINT - Rolls back the current transaction to a savepoint.
• LOCK - Locks a table.
• SET CONSTRAINTS - Sets constraint check timing for the current transaction.

Configuration Parameter

• SET - Changes the value of a run-time Cloudberry Database configuration parameter.
• RESET - Restores the value of a run-time system configuration parameter to the default value.
• SHOW - Shows the value of a run-time system configuration parameter.

SQL Statement

• PREPARE - Prepares a statement for execution.
• DEALLOCATE - Deallocates a prepared statement.
• EXECUTE - Runs a prepared SQL statement.
• EXPLAIN - Shows the query plan of a statement.