postgresql中文学习手册是基于PostgreSQL9.1设计的一款入门教程，包括表、数组、模式匹配、序列操作函数和索引等多种内容，从简单开始介绍帮助用户快速上手postgresql编程，内容详细，并且有实例说明，更容易理解。

目录介绍：

PostgreSQL 学习手册(数据表) .............................................................................................................................................. 4

一、表的定义： ............................................................................................................................................................... 4

PostgreSQL 学习手册(模式 Schema) ..................................................................................................................................... 9

PostgreSQL 学习手册(表的继承和分区) ............................................................................................................................ 10

一、表的继承： ............................................................................................................................................................. 10

PostgreSQL 学习手册(常用数据类型) ................................................................................................................................ 16

一、数值类型： ............................................................................................................................................................. 16

六、数组： ..................................................................................................................................................................... 22

PostgreSQL 学习手册(函数和操作符<一>) ........................................................................................................................ 25

一、逻辑操作符： ......................................................................................................................................................... 25

四、字符串函数和操作符： ......................................................................................................................................... 27

五、位串函数和操作符： ............................................................................................................................................. 29

PostgreSQL 学习手册(函数和操作符<二>) ........................................................................................................................ 30

六、模式匹配： ............................................................................................................................................................. 30

八、时间/日期函数和操作符： .................................................................................................................................... 33

PostgreSQL 学习手册(函数和操作符<三>) ........................................................................................................................ 35

九、序列操作函数： ..................................................................................................................................................... 35

十二、系统信息函数： ................................................................................................................................................. 38

PostgreSQL 学习手册(索引) ................................................................................................................................................ 42

一、索引的类型： ......................................................................................................................................................... 42

四、唯一索引： ............................................................................................................................................................. 43

PostgreSQL 学习手册(事物隔离) ...................................................................................................................................... 45

PostgreSQL 学习手册(性能提升技巧) ................................................................................................................................ 46

一、使用 EXPLAIN： ...................................................................................................................................................... 46

PostgreSQL 学习手册(服务器配置) .................................................................................................................................. 50

一、服务器进程的启动和关闭： ................................................................................................................................. 50

PostgreSQL 学习手册(角色和权限) .................................................................................................................................... 52

PostgreSQL 学习手册(数据库管理) ................................................................................................................................ 54

一、概述： ..................................................................................................................................................................... 54

PostgreSQL 学习手册(数据库维护) .................................................................................................................................. 56

一、恢复磁盘空间： ..................................................................................................................................................... 56

二、更新规划器统计： ................................................................................................................................................. 57

四、定期重建索引： ..................................................................................................................................................... 59

PostgreSQL 学习手册(系统表) ............................................................................................................................................ 61

一、pg_class: .................................................................................................................................................................. 61

三、pg_attrdef: ............................................................................................................................................................... 63

四、pg_authid: ................................................................................................................................................................ 64

五、pg_auth_members: ................................................................................................................................................. 64

七、pg_tablespace: ......................................................................................................................................................... 65

十、pg_index: ................................................................................................................................................................. 67

PostgreSQL 学习手册(系统视图) ........................................................................................................................................ 68

一、pg_tables: ................................................................................................................................................................ 68

二、pg_indexes: .............................................................................................................................................................. 68

三、pg_views: ................................................................................................................................................................. 68

四、pg_user: ................................................................................................................................................................... 69

五、pg_roles: .................................................................................................................................................................. 69

六、pg_rules: .................................................................................................................................................................. 69

七、pg_settings: ............................................................................................................................................................. 70

PostgreSQL 学习手册(客户端命令<一>) ............................................................................................................................ 70

零、口令文件： ............................................................................................................................................................. 70

PostgreSQL 学习手册(客户端命令<二>) ............................................................................................................................ 75

七、pg_dump:................................................................................................................................................................. 75

八、pg_restore: .............................................................................................................................................................. 77

PostgreSQL 学习手册(SQL 语言函数) ................................................................................................................................. 83

一、基本概念： ............................................................................................................................................................. 83

PostgreSQL 学习手册(PL/pgSQL 过程语言) ....................................................................................................................... 86

一、概述： ..................................................................................................................................................................... 86

手册内容预览