该作品是PDF文件格式请下载 福昕PDF阅读器

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

未经书面许可，严禁将本网内容作为AI训练资源。