Chapter 13. PostgreSQL Reference Guide

Table of Contents
ABORT — Rolls back changes made during a transaction block.
ALTER GROUP — Modifies the structure of a user group.
ALTER TABLE — Modifies table, row, and column attributes.
ALTER USER — Modifies user account properties and permissions.
BEGIN — Starts a chained-mode transaction block.
CLOSE — Closes a previously defined cursor object.
CLUSTER — Provides the backend server with clustering information about a table.
COMMENT — Adds a comment to an object within the database.
COMMIT — Ends the current transaction block and finalizes changes made within it.
COPY — Copeis filesystem data and row data between files andt tables. Copies data between files and tables
CREATE AGGREGATE — Defines a new aggregate function within the database.
CREATE CONSTRAINT TRIGGER — Creates a trigger for use with a constraint.
CREATE DATABASE — Creates a new database on the system.
CREATE FUNCTION — Defines a new function within the database.
CREATE GROUP — Creates a new user group within the database.
CREATE INDEX — Constructs an index on a table.
CREATE LANGUAGE — Defines a new language to be used by functions.
CREATE OPERATOR — Defines a new operator within the database.
CREATE RULE — Defines a new rule on a table.
CREATE SEQUENCE — Creates a new sequence number generator.
CREATE TABLE — Creates a new table.
CREATE TABLE AS — Creates a new table built from data retrieved by a SELECT.
CREATE TRIGGER — Creates a new trigger.
CREATE TYPE — Defines a new data type for use in the database.
CREATE USER — Creates a new user account.
CREATE VIEW — Creates a new view on a table.
createdb — Creates a new database from the command line.
createlang — Defines a new programming language for use by functions within a database.
createuser — Adds a new user account to a database.
SQL_CURRENT_DATE — Returns the current date.
SQL_CURRENT_TIME — Returns the current time.
SQL_CURRENT_TIMESTAMP — Returns the current date and time.
SQL_CURRENT_USER — Returns the current database username.
DECLARE — Defines a new cursor.
DELETE — Removes rows from a table.
DROP AGGREGATE — Removes the definition of an aggregate function from the database.
DROP DATABASE — Removes a database from the system.
DROP FUNCTION — Removes a user-defined C function.
DROP GROUP — Removes a user group from the database.
DROP INDEX — Removes an index from a database.
DROP LANGUAGE — Removes the definition of a procedural language.
DROP OPERATOR — Removes an operator from the database.
DROP RULE — Removes a rule from a database.
DROP SEQUENCE — Removes an existing sequence from a database.
DROP TABLE — Removes a table from a database
DROP TRIGGER — Removes the definition of a trigger from a database.
DROP TYPE — Removes a type from the system catalogs.
DROP USER — Removes a user account from a database.
DROP VIEW — Removes an existing view from a database.
dropdb — Removes a database from the system.
droplang — Removes the definition of a procedural language from a database.
dropuser — Removes a user account from a database.
ecpg — The embedded SQL C preprocessor.
END — Ends the current transaction block and finalizes its modifications.
EXPLAIN — Shows the statement execution plan for a supplied query.
FETCH — Retrieves rows from a cursor.
GRANT — Grants access privileges to a user, group, or all of the users in the database.
initdb — Creates a new database cluster.
initlocation — Create a secondary PostgreSQL database storage area
INSERT — Inserts new rows into a table.
ipcclean — Cleans shared memory resources left behind by aborted backend processes.
LISTEN — Listen for a notification event.
LOAD — Dynamically loads object files into a database.
LOCK — Explicitly locks a specified table within the current transaction.
MOVE — Repositions the cursor to another row.
NOTIFY — Signals all backends that are listening for the specified notify event.
pg_dump — Exports a database to a script file.
pg_dumpall — Exports all databases on the system to a script file.
pg_ctl — Starts, stops, and restarts postmaster.
pgtclsh — The TCL database client.
pgtksh — A graphical TCL/TK database client.
postgres — Runs a single-user backend process.
postmaster — Executes the PostgreSQL multi-user backend process.
psql — The PostgreSQL interactive terminal.
REINDEX — Rebuilds indexes on tables.
RESET — Restores run-time variables to their default settings.
REVOKE — Revokes access privileges from a user, a group, or all users.
ROLLBACK — Aborts the current transaction black and abandons any modifications it would have made.
SELECT — Retrieves rows from a table or view.
SELECT INTO — Construct a new table from the results of a SELECT.
SET — Set run-time variables.
SET CONSTRAINTS — Sets the constraint mode for the current transaction block.
SET TRANSACTION — Sets the transaction isolation mode for the current transaction block.
SHOW — Displays the values of run-time variables.
TRUNCATE — Empties the contents of a table.
UNLISTEN — Stops the backend process from listening for a notification event.
UPDATE — Modifies the values of column data within a table.
VACUUM — Cleans and analyzes a database.
vacuumdb — Cleans and analyzes a database.