Unsupported versions: 6.3
This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the current version, or one of the other supported versions listed above instead.

PostgreSQL

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
I. Tutorial
1. Introduction
What is Postgres?
A Short History of Postgres
About This Release
Resources
Copyrights and Trademarks
2. Architecture
Postgres Architectural Concepts
3. Getting Started
Setting Up Your Environment
Starting the Interactive Monitor (psql)
Managing a Database
4. The Query Language
Interactive Monitor
Concepts
Creating a New Class
Populating a Class with Instances
Querying a Class
Redirecting SELECT Queries
Joins Between Classes
Updates
Deletions
Using Aggregate Functions
5. Advanced Postgres SQL Features
Inheritance
Non-Atomic Values
Time Travel
More Advanced Features
II. User's Guide
6. Setting Up Your Environment
7. Managing a Database
Database Creation
Alternate Database Locations
Accessing a Database
Destroying a Database
8. Data Types
Numeric Types
Monetary Type
Character Types
Date/Time Types
Boolean Type
Geometric Types
9. Operators
10. Functions
11. Arrays
12. Inheritance
13. 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
14. Disk Storage
15. psql
16. pgaccess
III. Administrator's Guide
17. Ports
Currently Supported Platforms
Unsupported Platforms
18. Installation
Requirements to Run Postgres
Installation Procedure
Playing with Postgres
The Next Step
Porting Notes
19. Runtime Environment
Locale Support
20. Starting postmaster
21. Adding and Deleting Users
22. Disk Management
Alternate Locations
23. Troubleshooting
24. Managing a Database
Creating a Database
Accessing a Database
Destroying a Database
25. Database Recovery
26. Regression Test
Regression Environment
Directory Layout
Regression Test Procedure
Regression Analysis
27. Release Notes
Release 6.3
Release 6.2.1
Release 6.2
Release 6.1
Timing Results
IV. Programmer's Guide
28. Introduction
Copyrights and Trademarks
29. Architecture
Postgres Architectural Concepts
30. Extending SQL: An Overview
How Extensibility Works
The Postgres Type System
About the Postgres System Catalogs
31. Extending SQL: Functions
Query Language (SQL) Functions
Programming Language Functions
32. Extending SQL: Types
User-Defined Types
33. Extending SQL: Operators
34. Extending SQL: Aggregates
35. Interfacing Extensions To Indices
36. GiST Indices
37. Linking Dynamically-Loaded Functions
ULTRIX
DEC OSF/1
SunOS 4.x, Solaris 2.x and HP-UX
38. Triggers
Trigger Creation
Interaction with the Trigger Manager
Visibility of Data Changes
Examples
39. Server Programming Interface
Interface Functions
Interface Support Functions
Memory Management
Visibility of Data Changes
Examples
40. libpq
Control and Initialization
Database Connection Functions
Query Execution Functions
Fast Path
Asynchronous Notification
Functions Associated with the COPY Command
libpq Tracing Functions
User Authentication Functions
BUGS
Sample Programs
V. Reference
41. Functions
42. Large Objects
Historical Note
Inversion Large Objects
Large Object Interfaces
Built in registered functions
Accessing Large Objects from LIBPQ
Sample Program
43. ecpg - Embedded SQL in C
Why Embedded SQL?
The Concept
How To Use egpc
Limitations
Porting From Other RDBMS Packages
Installation
For the Developer
44. libpq
Control and Initialization
Database Connection Functions
Query Execution Functions
Fast Path
Asynchronous Notification
Functions Associated with the COPY Command
libpq Tracing Functions
User Authentication Functions
BUGS
Sample Programs
45. pgtcl
Commands
Examples
Reference Information
46. ODBC Interface
Background
47. JDBC Interface
VI. Developer's Guide
48. Architecture
Postgres Architectural Concepts
49. Genetic Query Optimization in Database Systems
50. Frontend/Backend Protocol
Overview
Protocol
Message Data Types
Message Formats
51. GCC Default Optimizations
VII. Appendices
A. Documentation
Introduction
Styles and Conventions
Building Documentation
Toolsets
Hardcopy Generation for v6.3
Alternate Toolsets
B. Contacts
Introduction
People
SQL References
Index

    Next
    Summary