Historical version. PostgreSQL 7.1 reached end of support in April 2006. See the
current version for supported releases.
The PostgreSQL Global Development Group
Copyright © 1996-2001 by PostgreSQL Global Development Group
- Table of Contents
- I. SQL Commands
-
- ABORT -- Aborts the current transaction
- ALTER GROUP -- Add users to a group, remove users from a group
- ALTER TABLE -- Modifies table properties
- ALTER USER -- Modifies user account information
- BEGIN -- Begins a transaction in chained mode
- CHECKPOINT -- Force transaction log checkpoint
- CLOSE -- Close a cursor
- CLUSTER -- Gives storage clustering advice to the server
- COMMENT -- Add comment to an object
- COMMIT -- Commits the current transaction
- COPY -- Copies data between files and tables
- CREATE AGGREGATE -- Defines a new aggregate function
- CREATE CONSTRAINT TRIGGER -- Create a trigger to support a constraint
- CREATE DATABASE -- Creates a new database
- CREATE FUNCTION -- Defines a new function
- CREATE GROUP -- Creates a new group
- 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 from the results of a SELECT
- CREATE TRIGGER -- Creates a new trigger
- CREATE TYPE -- Defines a new base data type
- CREATE USER -- Creates a new database user
- CREATE VIEW -- Constructs a virtual table
- DECLARE -- Defines a cursor for table access
- DELETE -- Removes rows from a table
- DROP AGGREGATE -- Removes the definition of an aggregate function
- DROP DATABASE -- Removes an existing database
- DROP FUNCTION -- Removes a user-defined C function
- DROP GROUP -- Removes a group
- DROP INDEX -- Removes existing indexes from a database
- DROP LANGUAGE -- Removes a user-defined procedural language
- DROP OPERATOR -- Removes an operator from the database
- DROP RULE -- Removes existing rules from the database
- DROP SEQUENCE -- Removes existing sequences from a database
- DROP TABLE -- Removes existing tables from a database
- DROP TRIGGER -- Removes the definition of a trigger
- DROP TYPE -- Removes user-defined types from the system catalogs
- DROP USER -- Removes a user
- DROP VIEW -- Removes existing views from a database
- END -- Commits the current transaction
- EXPLAIN -- Shows statement execution plan
- 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 a response on a notify condition
- LOAD -- Dynamically loads an object file
- LOCK -- Explicitly lock a table inside a transaction
- MOVE -- Moves cursor position
- NOTIFY -- Signals all frontends and backends listening on a notify condition
- REINDEX -- Recover corrupted system indexes under stand-alone Postgres
- RESET -- Restores run-time parameters to default values
- REVOKE -- Revokes access privilege from a user, a group or all users.
- ROLLBACK -- Aborts the current transaction
- SELECT -- Retrieves rows from a table or view
- SELECT INTO -- Creates a new table from the results of a SELECT
- SET -- Set run-time parameters
- SET CONSTRAINTS -- Set the constraint mode of the current SQL-transaction
- SET TRANSACTION -- Set the characteristics of the current SQL-transaction
- SHOW -- Shows run-time parameters
- TRUNCATE -- Empty a table
- UNLISTEN -- Stop listening for notification
- UPDATE -- Replaces values of columns in a table
- VACUUM -- Clean and analyze a Postgres database
- II. PostgreSQL Client Applications
-
- createdb -- Create a new Postgres database
- createuser -- Create a new Postgres user
- dropdb -- Remove an existing Postgres database
- dropuser -- Drops (removes) a Postgres user
- ecpg -- Embedded SQL C preprocessor
- pgaccess -- PostgreSQL graphical client
- pgadmin -- Postgres database management and design tool for Windows 95/98/NT
- pg_config -- Provides information about the installed version of PostgreSQL
- pg_dump -- Extract a Postgres database into a script file or other archive file
- pg_dumpall -- Extract all databases into a script file
- pg_restore -- Restore a Postgres database from an archive file created by pg_dump
- psql -- Postgres interactive terminal
- pgtclsh -- PostgreSQL Tcl shell client
- pgtksh -- PostgreSQL Tcl/Tk shell client
- vacuumdb -- Clean and analyze a Postgres database
- III. PostgreSQL Server Applications
-
- createlang -- Add a new programming language to a Postgres database
- droplang -- Remove a programming language from a Postgres database
- initdb -- Create a new Postgres database cluster
- initlocation -- Create a secondary Postgres database storage area
- ipcclean -- Clean up shared memory and semaphores from aborted backends
- pg_ctl -- Starts, stops, or restarts postmaster
- pg_passwd -- Manipulate a text password file
- postgres -- Run a PostgreSQL single-user backend
- postmaster -- PostgreSQL multi-user database server