PostgreSQL User's Guide

Covering v6.3 for general release

by The PostgreSQL Development Team

Edited by Thomas Lockhart

(last updated 1998-02-23)

PostgreSQL is copyright (C) 1998 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
Copyrights and Trademarks
2. Setting Up Your Environment
3. Managing a Database
Database Creation
Alternate Database Locations
Accessing a Database
Database Privileges
Table Privileges
Destroying a Database
4. Data Types
Numeric Types
Monetary Type
Character Types
Date/Time Types
Date/Time Styles
Time Zones
Date/Time Input
datetime
timespan
abstime
reltime
timestamp
interval
tinterval
Boolean Type
Geometric Types
Point
Line Segment
Box
Path
Polygon
Circle
5. Operators
6. Functions
7. Arrays
8. Inheritance
9. The Query Language
Concepts
Creating a New Class
Populating a Class with Instances
Querying a Class
Redirecting SELECT Queries
Joins Between Classes
Updates
Deletions
Using Aggregate Functions
10. Disk Storage
11. psql
12. pgaccess
SQL References
Index
  Next
  Summary