Postgresql 中文操作指南

本部分介绍在 PostgreSQL 中使用 SQL 语言。我们首先介绍 SQL 的通用语法，然后说明如何创建用于保存数据的结构、填充数据库以及查询数据库。中间部分列出可在 SQL 命令中使用的可用数据类型和函数。其余部分讨论影响数据库最佳性能调优的几个重要方面。

This part describes the use of the SQL language in PostgreSQL. We start with describing the general syntax of SQL, then explain how to create the structures to hold data, how to populate the database, and how to query it. The middle part lists the available data types and functions for use in SQL commands. The rest treats several aspects that are important for tuning a database for optimal performance.

本部分中的信息安排方式旨在帮助新手用户从头到尾进行了解，全面理解这些主题，而无需太多地向后参考。这些章节旨在自成一体，因此高级用户可以选择性地阅读各个章节。本部分中的信息以叙述方式按主题单元呈现。希望看到特定命令完整描述的读者应参阅 Part VI。

The information in this part is arranged so that a novice user can follow it start to end to gain a full understanding of the topics without having to refer forward too many times. The chapters are intended to be self-contained, so that advanced users can read the chapters individually as they choose. The information in this part is presented in a narrative fashion in topical units. Readers looking for a complete description of a particular command should see Part VI.

本部分的读者应了解如何连接到 PostgreSQL 数据库并发出 SQL 命令。不熟悉这些问题的读者应首先阅读 Part I。SQL 命令通常使用 PostgreSQL 交互式终端 psql 输入，但也可以使用具有类似功能的其他程序。

Readers of this part should know how to connect to a PostgreSQL database and issue SQL commands. Readers that are unfamiliar with these issues are encouraged to read Part I first. SQL commands are typically entered using the PostgreSQL interactive terminal psql, but other programs that have similar functionality can be used as well.

Table of Contents