|
Code |
Description |
| ABORT |
Aborts the current transaction
|
| ALTER TABLE |
Modifies table properties
|
| ALTER USER |
Modifies user account information
|
| BEGIN WORK |
Begins a transaction
|
| CLOSE |
Close a cursor
|
| CLUSTER |
Gives storage clustering advice to the backend
|
| COMMIT |
Commits the current transaction
|
| COPY |
Copies data between files and tables
|
| CREATE AGGREGATE |
Defines a new aggregate function
|
| CREATE DATABASE |
Creates a new database
|
| CREATE FUNCTION |
Defines a new function
|
| CREATE INDEX |
Constructs a secondary index
|
| CREATE LANGUAGE |
Defines a new language for functions
|
| CREATE OPERATOR |
Defines a new user operator
|
| CREATE RULE |
Defines a new rule
|
| CREATE SEQUENCE |
Creates a new sequence number generator
|
| CREATE TABLE |
Creates a new table
|
| CREATE TABLE AS |
Creates a new table
|
| CREATE TRIGGER |
Creates a new trigger
|
| CREATE TYPE |
Defines a new base data type
|
| CREATE USER |
Creates account information for a new user
|
| CREATE VIEW |
Constructs a virtual table
|
| DECLARE |
Defines a cursor for table access
|
| DELETE |
Deletes rows from a table
|
| DROP AGGREGATE |
Removes the definition of an aggregate function
|
| DROP DATABASE |
Destroys an existing database
|
| DROP FUNCTION |
Removes a user-defined C function
|
| DROP INDEX |
Removes an index from a database
|
| DROP LANGUAGE |
Removes a user-defined procedural language
|
| DROP OPERATOR |
Removes an operator from the database
|
| DROP RULE |
Removes an existing rule from the database
|
| DROP SEQUENCE |
Removes an existing sequence
|
| DROP TABLE |
Removes existing tables from a database
|
| DROP TRIGGER |
Removes the definition of a trigger
|
| DROP TYPE |
Removes a user-defined type from the system catalogs
|
| DROP USER |
Removes an user account information
|
| DROP VIEW |
Removes an existing view from a database
|
| EXPLAIN |
Shows statement execution details |
| FETCH |
Gets rows using a cursor
|
| GRANT |
Grants access privilege to a user, a group or all users
|
| INSERT |
Inserts new rows into a table
|
| LISTEN |
Listen for notification on a notify condition
|
| LOAD |
Dynamically loads an object file
|
| LOCK |
Explicit lock of a table inside a transaction
|
| MOVE |
Moves cursor position
|
| NOTIFY |
Signals all frontends and backends listening on a notify
condition
|
| RESET |
Restores run-time parameters for session to default values
|
| REVOKE |
Revokes access privilege from a user, a group or all users.
|
| ROLLBACK |
Aborts the current transaction
|
| SELECT |
Retrieve rows from a table or view
|
| SELECT INTO |
Create a new table from an existing table or view
|
| SET |
Set run-time parameters for session
|
| SHOW |
Shows run-time parameters for session
|
| UNLISTEN |
Stop listening for notification
|
| UPDATE |
Replaces values of columns in a table
|