目 录
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
