PostgreSQL User's Guide

The PostgreSQL Development Team

Edited by

Thomas Lockhart

PostgreSQL is copyright (C) 1998 by the Postgres Global Development Group.

Table of Contents

1. Introduction

What is Postgres?

A Short History of Postgres

The Berkeley Postgres Project
Postgres95
PostgreSQL

About This Release

Terminology

Y2K Statement

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. SQL Syntax

Reserved Key Words
Non-reserved Keywords

5. 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

IP Version 4 Networks and Host Addresses

inet for IP Networks
inet for IP Networks

6. Operators

Lexical Precedence
General Operators
Numerical Operators
Geometric Operators
Time Interval Operators
IP V4 Operators
IP V4 Operators

7. Functions

Mathematical Functions
String Functions
Date/Time Functions
Geometric Functions
IP V4 Functions

8. Type Conversion

Guidelines

Conversion Procedure
Examples

Examples

Query Targets

Examples

UNION Queries

Examples

9. Indices and Keys

11. Inheritance

12. 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

13. Disk Storage

Paging To Screen

15. pgaccess

16. SQL Commands

17. Utility Applications

createdb
createuser
destroydb
destroyuser
initdb
initlocation
pg_dump
pg_dumpall
psql

SQL References

		Next
		Summary