PostgreSQL User's Guide

The PostgreSQL Development Team

Edited by

Thomas Lockhart

PostgreSQL is Copyright © 1996-9 by the Postgres Global Development Group.

Table of Contents
Summary
1. Introduction
What is Postgres?
A Short History of Postgres
The Berkeley Postgres Project
Postgres95
PostgreSQL
About This Release
Resources
Terminology
Notation
Y2K Statement
Copyrights and Trademarks
2. SQL Syntax
Key Words
Reserved Key Words
Non-reserved Keywords
Comments
Names
Constants
String Constants
Integer Constants
Floating Point Constants
Constants of Postgres User-Defined Types
Array constants
Fields and Columns
Fields
Columns
Operators
Expressions
Parameters
Functional Expressions
Aggregate Expression
Target List
Qualification
From List
3. Data Types
Numeric Types
The Serial Type
Monetary Type
Character Types
Date/Time Types
SQL92 Conventions
Date/Time Styles
Calendar
Time Zones
Date/Time Input
datetime
timespan
abstime
reltime
timestamp
interval
tinterval
Boolean Type
Geometric Types
Point
Line Segment
Box
Path
Polygon
Circle
IP Version 4 Networks and Host Addresses
CIDR
inet
4. Operators
Lexical Precedence
General Operators
Numerical Operators
Geometric Operators
Time Interval Operators
IP V4 CIDR Operators
IP V4 INET Operators
5. Functions
SQL Functions
Mathematical Functions
String Functions
Date/Time Functions
Geometric Functions
IP V4 Functions
6. Type Conversion
Overview
Guidelines
Operators
Conversion Procedure
Examples
Functions
Examples
Query Targets
Examples
UNION Queries
Examples
7. Indices and Keys
Keys
Partial Indices
8. Arrays
9. Inheritance
10. Multi-Version Concurrency Control
Introduction
Transaction Isolation
Read Committed Isolation Level
Serializable Isolation Level
Locking and Tables
Table-level locks
Row-level locks
Locking and Indices
Data consistency checks at the application level
11. Setting Up Your Environment
12. Managing a Database
Database Creation
Alternate Database Locations
Accessing a Database
Database Privileges
Table Privileges
Destroying a Database
13. Disk Storage
14. SQL Commands
ABORT
ALTER TABLE
ALTER USER
BEGIN
CLOSE
CLUSTER
COMMIT
COPY
CREATE AGGREGATE
CREATE DATABASE
CREATE FUNCTION
CREATE INDEX
CREATE LANGUAGE
CREATE OPERATOR
CREATE RULE
CREATE SEQUENCE
CREATE TABLE
CREATE TABLE AS
CREATE TRIGGER
CREATE TYPE
CREATE USER
CREATE VIEW
DECLARE
DELETE
DROP AGGREGATE
DROP DATABASE
DROP FUNCTION
DROP INDEX
DROP LANGUAGE
DROP OPERATOR
DROP RULE
DROP SEQUENCE
DROP TABLE
DROP TRIGGER
DROP TYPE
DROP USER
DROP VIEW
END
EXPLAIN
FETCH
GRANT
INSERT
LISTEN
LOAD
LOCK
MOVE
NOTIFY
RESET
REVOKE
ROLLBACK
SELECT
SELECT INTO
SET
SHOW
UNLISTEN
UPDATE
VACUUM
15. Applications
createdb
createlang
createuser
destroydb
destroylang
destroyuser
ecpg
pgaccess
pgadmin
pg_dump
pg_dumpall
psql
pgtclsh
pgtksh
vacuumdb
16. System Applications
initdb
initlocation
ipcclean
pg_passwd
pg_upgrade
postgres
postmaster
UG1. Date/Time Support
Time Zones
History
Bibliography
  Next
  Summary