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

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.