0.前言

PostgreSQL为开源软件，只要在相应的拷贝中保留以下信息，即可免费使用该软件及其文档。

Legal Notice

PostgreSQL is Copyright 1996-2019 by the PostgreSQL Global Development Group.

Postgres95 is Copyright 1994-5 by the Regents of the University of California.

Permission to use, copy, modify, and distribute this software and its documentation for any purpose, without fee, and without a written

agreement is hereby granted, provided that the above copyright notice and this paragraph and the following two paragraphs appear in all copies.

IN NO EVENT SHALL THE UNIVERSITY OF CALIFORNIA BE LIABLE TO ANY PARTY FOR DIRECT, INDIRECT, SPECIAL,INCIDENTAL, OR CONSEQUENTIAL DAMAGES, INCLUDING LOST PROFITS, ARISING OUT OF THE USE OF THIS SOFTWARE AND ITS DOCUMENTATION, EVEN IF THE UNIVERSITY OF CALIFORNIA HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.

THE UNIVERSITY OF CALIFORNIA SPECIFICALLY DISCLAIMS ANY WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. THE SOFTWARE PROVIDED HEREUNDER IS ON AN “AS-IS” BASIS, AND THE UNIVERSITY OF CALIFORNIA HAS NO OBLIGATIONS TO PROVIDE MAINTENANCE, SUPPORT, UPDATES, ENHANCEMENTS, OR MODIFICATIONS.

本文档是PostgreSQL的官方文档,是由PG开发者及其他志愿者共同编写，涵盖了当前版本官方支持的所有功能。

关于PG的资料有很多，为方便管理，本文档按部分对其进行组织。每一部分针对不同的用户类型，或者针对处于PG使用不同阶段的用户：

• 第一部分是对新用户简单的介绍一下PG；–针对初学者

• 第二部分介绍了SQL查询语言环境，包括数据类型和函数等，以及用户级别的性能调优。每个PG用户都应该阅读此部分；–所有PGer需学

• 第三部分描述了PG服务端的安装和管理。每个运行PG服务端的工程师，无论是为了个人使用还是为他人维护，都应该阅读此部分；–数据库运维（DBA）

• 第四部分描述了PG的客户端程序的编程接口；–程序员

• 第五部分是针对高级用户的，包含服务端的可扩展功能。包含用户自定义数据类型、函数等主题；–DBA进阶

• 第六部分包含了SQL命令、客户端和服务端的相关参考信息。这部分通过提供以命令或程序排序的结构化信息，给其他部分的使用提供支撑；–参考资料

• 第七部分包含可能对PG开发人员有用的各种信息；–数据库开发研发

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

To make the large amount of information about PostgreSQL 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 PostgreSQL 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 PostgreSQL user should read this.

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

Part IV describes the programming interfaces for PostgreSQL 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 PostgreSQL developers

1. What is PostgreSQL/p>

2. A Brief History of PostgreSQL

    2.1. The Berkeley POSTGRES Project

    2.2 Postgres95 

    2.3 PostgreSQL

3. Conventions

4. Further Information

5. Bug Reporting Guidelines

    5.1. Identifying Bugs

    5.2. What to Report

    5.3. Where to Report Bugs

文章知识点与官方知识档案匹配，可进一步学习相关知识PostgreSQL技能树首页概览4552 人正在系统学习中

来源：丹心明月