Reference Manual

 The following is a copy of the reference manual pages (man pages) as they appeared in POSTGRESQL 7.0.2. The most current version is available at:

• http://www.postgresql.org/docs/user/sql-commands.html
• http://www.postgresql.org/docs/user/applications.html

These are part of the POSTGRESQL User's Guide.

 

• ABORT
  • Name
    • Inputs
    • Outputs
  • Description
    • Notes
  • Usage
  • Compatibility
    • SQL92
• ALTER GROUP
  • Name
    • Inputs
    • Outputs
  • Description
  • Usage
  • Compatibility
    • SQL92
• ALTER TABLE
  • Name
    • Inputs
    • Outputs
  • Description
    • Notes
  • Usage
  • Compatibility
    • SQL92
• ALTER USER
  • Name
    • Inputs
    • Outputs
  • Description
  • Usage
  • Compatibility
    • SQL92
• BEGIN
  • Name
    • Inputs
    • Outputs
  • Description
    • Notes
  • Usage
  • Compatibility
    • SQL92
• CLOSE
  • Name
    • Inputs
    • Outputs
  • Description
    • Notes
  • Usage
  • Compatibility
    • SQL92
• CLUSTER
  • Name
    • Inputs
    • Outputs
  • Description
    • Notes
  • Usage
  • Compatibility
    • SQL92
• COMMENT
  • Name
    • Inputs
    • Outputs
  • Description
  • Usage
  • Compatibility
    • SQL92
• COMMIT
  • Name
    • Inputs
    • Outputs
  • Description
    • Notes
  • Usage
  • Compatibility
    • SQL92
• COPY
  • Name
    • Inputs
    • Outputs
  • Description
    • Notes
  • File Formats
    • Text Format
    • Binary Format
    • Alignment of Binary Data
  • Usage
  • Compatibility
    • SQL92
• CREATE AGGREGATE
  • Name
    • Inputs
    • Outputs
  • Description
    • Notes
  • Usage
  • Compatibility
    • SQL92
• CREATE CONSTRAINT TRIGGER
  • Name
    • Inputs
    • Outputs
  • Description
• CREATE DATABASE
  • Name
    • Inputs
    • Outputs
  • Description
    • Notes
  • Usage
  • Compatibility
    • SQL92
• CREATE FUNCTION
  • Name
    • Inputs
    • Outputs
  • Description
    • Notes
  • Usage
  • Compatibility
    • SQL92
    • SQL/PSM
• CREATE GROUP
  • Name
    • Inputs
    • Outputs
  • Description
  • Usage
  • Compatibility
    • SQL92
• CREATE INDEX
  • Name
    • Inputs
    • Outputs
  • Description
    • Notes
  • Usage
  • Compatibility
    • SQL92
• CREATE LANGUAGE
  • Name
    • Inputs
    • Outputs
  • Description
    • Writing PL handlers
    • Notes
  • Usage
  • Compatibility
    • SQL92
• CREATE OPERATOR
  • Name
    • Inputs
    • Outputs
  • Description
    • Notes
  • Usage
  • Compatibility
    • SQL92
• CREATE RULE
  • Name
    • Inputs
    • Outputs
  • Description
    • Notes
    • Example of a circular rewrite rule combination.
  • Usage
  • Compatibility
    • SQL92
• CREATE SEQUENCE
  • Name
    • Inputs
    • Outputs
  • Description
    • Notes
  • Usage
  • Compatibility
    • SQL92
• CREATE TABLE
  • Name
    • Inputs
    • Outputs
  • Description
  • DEFAULT Clause
    • Inputs
    • Outputs
    • Description
    • Usage
  • Column CONSTRAINT Clause
    • Inputs
    • Description
    • NOT NULL Constraint
    • Outputs
  • Description
    • Usage
    • UNIQUE Constraint
    • Inputs
    • Outputs
    • Description
    • Usage
    • The CHECK Constraint
    • Inputs
    • Outputs
    • Description
    • PRIMARY KEY Constraint
    • Inputs
    • Outputs
    • Description
    • Notes
    • REFERENCES Constraint
    • Inputs
    • Description
    • Notes
  • Table CONSTRAINT Clause
    • Inputs
    • Outputs
    • Description
    • UNIQUE Constraint
    • Inputs
    • Outputs
    • Description
    • Usage
    • PRIMARY KEY Constraint
    • Inputs
    • Outputs
    • Description
    • REFERENCES Constraint
    • Inputs
    • Outputs
    • Description
  • Usage
    • Notes
  • Compatibility
    • SQL92
• CREATE TABLE AS
  • Name
    • Inputs
    • Outputs
  • Description
• CREATE TRIGGER
  • Name
    • Inputs
    • Outputs
  • Description
    • Notes
  • Usage
  • Compatibility
    • SQL92
• CREATE TYPE
  • Name
    • Inputs
    • Outputs
  • Description
    • Array Types
    • Large Object Types
  • Examples
    • Notes
  • Compatibility
    • SQL3
• CREATE USER
  • Name
    • Inputs
    • Outputs
  • Description
  • Usage
  • Compatibility
    • SQL92
• CREATE VIEW
  • Name
    • Inputs
    • Outputs
  • Description
    • Notes
  • Usage
  • Compatibility
    • SQL92
• createdb
  • Name
    • Inputs
    • Outputs
  • Description
  • Usage
• createlang
  • Name
    • Inputs
    • Outputs
  • Description
  • Notes
  • Usage
• createuser
  • Name
    • Inputs
    • Outputs
  • Description
  • Usage
• DECLARE
  • Name
    • Inputs
    • Outputs
  • Description
    • Notes
  • Usage
  • Compatibility
    • SQL92
• DELETE
  • Name
    • Inputs
    • Outputs
  • Description
  • Usage
  • Compatibility
    • SQL92
• DROP AGGREGATE
  • Name
    • Inputs
    • Outputs
  • Description
    • Notes
  • Usage
  • Compatibility
    • SQL92
• DROP DATABASE
  • Name
    • Inputs
    • Outputs
  • Description
    • Notes
  • Compatibility
    • SQL92
• DROP FUNCTION
  • Name
    • Inputs
    • Outputs
  • Description
    • Notes
  • Usage
  • Compatibility
    • SQL92
    • SQL/PSM
• DROP GROUP
  • Name
    • Inputs
    • Outputs
  • Description
  • Usage
  • Compatibility
    • SQL92
• DROP INDEX
  • Name
    • Inputs
    • Outputs
  • Description
    • Notes
  • Usage
  • Compatibility
    • SQL92
• DROP LANGUAGE
  • Name
    • Inputs
    • Outputs
  • Description
    • Notes
  • Usage
  • Compatibility
    • SQL92
• DROP OPERATOR
  • Name
    • Inputs
    • Outputs
  • Description
    • Notes
  • Usage
  • Compatibility
    • SQL92
• DROP RULE
  • Name
    • Inputs
    • Outputs
  • Description
    • Notes
  • Usage
  • Compatibility
    • SQL92
• DROP SEQUENCE
  • Name
    • Inputs
    • Outputs
  • Description
    • Notes
  • Usage
  • Compatibility
    • SQL92
• DROP TABLE
  • Name
    • Inputs
    • Outputs
  • Description
    • Notes
  • Usage
  • Compatibility
    • SQL92
• DROP TRIGGER
  • Name
    • Inputs
    • Outputs
  • Description
    • Notes
  • Usage
  • Compatibility
    • SQL92
• DROP TYPE
  • Name
    • Inputs
    • Outputs
  • Description
    • Notes
  • Usage
  • Compatibility
    • SQL3
• DROP USER
  • Name
    • Inputs
    • Outputs
  • Description
  • Usage
  • Compatibility
    • SQL92
• DROP VIEW
  • Name
    • Inputs
    • Outputs
  • Description
    • Notes
  • Usage
  • Compatibility
    • SQL92
    • Inputs
    • Notes
• dropdb
  • Name
    • Inputs
    • Outputs
  • Description
  • Usage
• droplang
  • Name
    • Inputs
    • Outputs
  • Description
  • Notes
  • Usage
• dropuser
  • Name
    • Inputs
    • Outputs
  • Description
  • Usage
• ecpg
  • Name
    • Inputs
    • Outputs
  • Description
  • Usage
    • Preprocessing for Compilation
    • Compiling and Linking
  • Grammar
    • Libraries
    • Variable Declaration
    • Error Handling
    • Connecting to the Database Server
    • Queries
  • Notes
• END
  • Name
    • Inputs
    • Outputs
  • Description
    • Notes
  • Usage
  • Compatibility
    • SQL92
• EXPLAIN
  • Name
    • Inputs
    • Outputs
  • Description
    • Notes
  • Usage
  • Compatibility
    • SQL92
• FETCH
  • Name
    • Inputs
    • Outputs
  • Description
    • Notes
  • Usage
  • Compatibility
    • SQL92
• GRANT
  • Name
    • Inputs
    • Outputs
  • Description
    • Notes
  • Usage
  • Compatibility
    • SQL92
• initdb
  • Name
    • Inputs
    • Outputs
  • Description
• initlocation
  • Name
    • Inputs
    • Outputs
  • Description
  • Usage
• INSERT
  • Name
    • Inputs
    • Outputs
  • Description
  • Usage
  • Compatibility
    • SQL92
• ipcclean
  • Name
    • Inputs
    • Outputs
  • Description
• LISTEN
  • Name
    • Inputs
    • Outputs
  • Description
    • Notes
  • Usage
  • Compatibility
    • SQL92
• LOAD
  • Name
    • Inputs
    • Outputs
  • Description
    • Notes
  • Usage
  • Compatibility
    • SQL92
• LOCK
  • Name
    • Inputs
    • Outputs
  • Description
    • Notes
  • Usage
  • Compatibility
    • SQL92
• MOVE
  • Name
  • Description
    • Notes
  • Usage
  • Compatibility
    • SQL92
• NOTIFY
  • Name
    • Inputs
    • Outputs
  • Description
    • Notes
  • Usage
  • Compatibility
    • SQL92
• pg_ctl
  • Name
    • Inputs
    • Outputs
  • Description
  • Usage
    • Starting postmaster
    • Stopping postmaster
    • Restarting postmaster
    • postmaster status
• pg_dump
  • Name
    • Inputs
    • Outputs
  • Description
  • Notes
  • Usage
• pg_dumpall
  • Name
    • Inputs
    • Outputs
  • Description
  • Usage
• pg_passwd
  • Name
  • Description
• pg_upgrade
  • Name
  • Description
    • Upgrading Postgres with pg_upgrade
• pgaccess
  • Name
    • Inputs
    • Outputs
  • Description
• pgtclsh
  • Name
    • Inputs
    • Outputs
  • Description
• pgtksh
  • Name
    • Inputs
    • Outputs
  • Description
• postgres
  • Name
    • Inputs
    • Outputs
  • Description
  • Notes
• postmaster
  • Name
    • Inputs
    • Outputs
  • Description
  • Notes
  • Usage
• psql
  • Name
    • Summary
  • Description
    • Connecting To A Database
    • Entering Queries
  • psql Meta-Commands
  • Command-line Options
  • Advanced features
    • Variables
    • SQL Interpolation
    • Prompting
    • Miscellaneous
    • GNU readline
  • Examples
  • Appendix
    • Bugs and Issues
• REINDEX
  • Name
    • Inputs
    • Outputs
  • Description
  • Usage
  • Compatibility
    • SQL92
• RESET
  • Name
    • Inputs
    • Outputs
  • Description
    • Notes
  • Usage
  • Compatibility
    • SQL92
• REVOKE
  • Name
    • Inputs
    • Outputs
  • Description
    • Notes
  • Usage
  • Compatibility
    • SQL92
• ROLLBACK
  • Name
    • Inputs
    • Outputs
  • Description
    • Notes
  • Usage
  • Compatibility
    • SQL92
• SELECT
  • Name
    • Inputs
    • Outputs
  • Description
    • WHERE Clause
    • GROUP BY Clause
    • HAVING Clause
    • ORDER BY Clause
    • UNION Clause
    • INTERSECT Clause
    • EXCEPT Clause
    • LIMIT Clause
  • Usage
  • Compatibility
    • Extensions
    • SQL92
• SELECT INTO
  • Name
    • Inputs
    • Outputs
  • Description
• SET
  • Name
    • Inputs
    • Outputs
  • Description
    • Notes
  • Usage
  • Compatibility
    • SQL92
• SHOW
  • Name
    • Inputs
    • Outputs
  • Description
    • Notes
  • Usage
  • Compatibility
    • SQL92
• TRUNCATE
  • Name
    • Inputs
    • Outputs
  • Description
  • Usage
  • Compatibility
    • SQL92
• UNLISTEN
  • Name
    • Inputs
    • Outputs
  • Description
    • Notes
  • Usage
  • Compatibility
    • SQL92
• UPDATE
  • Name
    • Inputs
    • Outputs
  • Description
  • Usage
  • Compatibility
    • SQL92
• VACUUM
  • Name
    • Inputs
    • Outputs
  • Description
    • Notes
  • Usage
  • Compatibility
    • SQL92
• vacuumdb
  • Name
    • Inputs
    • Outputs
  • Description
  • Usage