The POSTGRES95 User Manual

Version 1.0 (September 5, 1995)

Andrew Yu and Jolly Chen
(with the POSTGRES Group)
Computer Science Div., Dept. of EECS
University of California at Berkeley

[an error occurred while processing this directive]

Table of Contents

1. INTRODUCTION
1.1. A Short History of POSTGRES
1.2. What is POSTGRES95?
1.4. About This Release
1.5. Outline of This Manual
2. ARCHITECTURE CONCEPTS
3. GETTING STARTED
3.1. Setting Up Your Enviroment
3.2. Starting The Postmaster
3.3. Adding And Deleting Users
3.4. Starting Applications
3.5. Managing A Database
3.5.1. Creating A Database
3.5.2. Accessing A Database
3.5.3. Destroying A Database
4. QUERY LANGUAGE
4.1. Concepts
4.2. Creating a New Class
4.3. Populating a Class with Instances
4.4. Querying a Class
4.5. Redirecting SELECT Queries
5. ADVANCED POSTGRES SQL FEATURES
5.1. Inheritance
5.2. Time Travel
5.3. Non-Atomic Values
5.3.1. Arrays
6. EXTENDING SQL: AN OVERVIEW
6.1. How Extensibility Works
6.2. The POSTGRES Type System
6.3. About the POSTGRES System Catalogs
7. EXTENDING SQL: FUNCTIONS
7.1. Query Language (SQL) Functions
7.1.1. SQL Functions on Base Types
7.2. Programming Language Functions
7.2.1. Programming Language Functions on Base Types
7.2.2. Programming Language Functions on Composite Types
7.2.3. Caveats
8. EXTENDING SQL: TYPES
8.1. User-Defined Types
8.1.1. Functions Needed for a User-Defined Type
8.1.2. Large Objects
9. EXTENDING SQL: OPERATORS
10. EXTENDING SQL: AGGREGATES
11. INTERFACING EXTENSIONS TO INDICES
12. LIBPQ
12.1. Control and Initialization
12.2. Database Connection Functions
12.3. Query Execution Functions
12.4. Fast Path
12.5. Asynchronous Notification
12.6. Functions Associated with the COPY Command
12.7. LIBPQ Tracing Functions
12.8. User Authentication Functions
12.9. BUGS
12.10. Sample Programs
12.10.1. Sample Program 1
12.10.2. Sample Program 2
12.10.3. Sample Program 3
13. LARGE OBJECTS
13.1. Historical Note
13.2. Inversion Large Objects
13.3. Large Object Interfaces
13.3.1. Creating a Large Object
13.3.2. Importing a Large Object
13.3.3. Exporting a Large Object
13.3.4. Opening an Existing Large Object
13.3.5. Writing Data to a Large Object
13.3.6. Seeking on a Large Object
13.3.7. Closing a Large Object Descriptor
13.4. Built in registered functions
13.5. Accessing Large Objects from LIBPQ
13.6. Sample Program
14. THE POSTGRES RULE SYSTEM
15. ADMINISTERING POSTGRES
16. REFERENCES

Appendix A: Linking Dynamically-Loaded Functions

HyperNews Forum - About this Manual.

POSTGRES95 is copyright © 1994-5 by the Regents of the University of California.

Converted to HTML by J. Douglas Dunlop <dunlop@eol.ists.ca>
The file pg95user.tgz contains the complete manual for download.