# Preface

This book is the official documentation of Postgres Pro Standard. It has been written by the Postgres Pro developers, PostgreSQL community, and other volunteers in parallel to the development of the PostgreSQL and Postgres Pro software. It describes all the functionality that the current version of Postgres Pro officially supports.

To make the large amount of information about Postgres Pro manageable, this book has been organized in several parts. Each part is targeted at a different class of users, or at users in different stages of their Postgres Pro experience:

- Part I is an informal introduction for new users.

- Part II documents the SQL query language environment, including data types and functions, as well as user-level performance tuning. Every Postgres Pro user should read this.

- Part III describes the installation and administration of the server. Everyone who runs a Postgres Pro server, be it for private use or for others, should read this part.

- Part IV describes the programming interfaces for Postgres Pro client programs.

- Part V contains information for advanced users about the extensibility capabilities of the server. Topics include user-defined data types and functions.

- Part VI contains reference information about SQL commands, client and server programs. This part supports the other parts with structured information sorted by command or program.

- Part VII contains assorted information that might be of use to Postgres Pro developers.

## 1. What is Postgres Pro Standard?

Postgres Pro Standard is an object-relational database management system (ORDBMS), developed by Postgres Professional in the Postgres Pro fork of PostgreSQL, which is in turn based on POSTGRES, Version 4.2, developed at the University of California at Berkeley Computer Science Department. POSTGRES pioneered many concepts that only became available in some commercial database systems much later.

Both PostgreSQL and Postgres Pro Standard support a large part of the SQL standard and offer many modern features:

- complex queries
- foreign keys
- triggers
- updatable views
- transactional integrity
- multiversion concurrency control

Besides, PostgreSQL and Postgres Pro can be extended by the user in many ways, for example by adding new

- data types
- functions
- operators
- aggregate functions
- index methods
- procedural languages