PostgreSQL中文手册

PostgreSQL 学习手册(模式 Schema) ..................................................................................................................................... 9 PostgreSQL 学习手册(表的继承和分区) ............................................................................................................................ 10
一、数值类型： ............................................................................................................................................................. 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