没有合适的资源?快使用搜索试试~ 我知道了~
首页PostgreSQL 13.1中文版翻译概览与版权信息
PostgreSQL 13.1中文版翻译概览与版权信息
需积分: 9 8 下载量 19 浏览量
更新于2024-07-03
收藏 11.33MB PDF 举报
"PostgreSQL13.1-CN-v1.0.pdf" 是由全球PostgreSQL开发团队发布的官方文档,针对PostgreSQL 13.1版本提供了详细的中文翻译。该文档由中国社区的翻译团队,特别是彭煜玮副教授、车岩磊、赵宇、苑浩、刘梦真和陈华军等志愿者共同完成。翻译工作是在PostgreSQL 12.2手册的基础上进行的,以确保内容的准确性和一致性。
这份中文手册是自PostgreSQL 9.6版本开始,对英文文档进行持续翻译和更新的结果。它涵盖了PostgreSQL数据库系统的核心概念、功能特性、SQL语法、系统管理、性能优化、数据类型以及错误处理等内容,旨在帮助中国用户更好地理解和使用这一强大的开源关系型数据库管理系统。
版权方面,PostgreSQL全球开发组保留了所有权利,允许用户在无需支付费用且不需书面协议的情况下使用、复制、修改和分发该软件及文档,但必须保留版权声明和相关条款。然而,使用时需要注意,未经授权的修改可能导致法律问题,且不适用于商业用途中的某些限制。
此外,如果在阅读中文手册过程中发现任何错误或需要改进的地方,用户可以向GitHub源代码仓库提交问题报告或修订请求,以便于社区进行持续的维护和更新。截至文档的最后更新日期2021年7月15日,这是一份1.0版的中文手册,反映了PostgreSQL 13.1的最新状态。
PostgreSQL13.1-CN-v1.0.pdf是PostgreSQL用户和开发者在中国寻求技术指导的重要参考资料,体现了开源社区的协作与贡献精神。对于希望深入理解并实践PostgreSQL的人来说,这个文档是必不可少的学习资源。
PostgreSQL 13.1 手册
51.9. pg_auth_members ............................................ 1895
51.10. pg_cast ................................................... 1895
51.11. pg_class .................................................. 1896
51.12. pg_collation .............................................. 1898
51.13. pg_constraint ............................................. 1899
51.14. pg_conversion ............................................. 1901
51.15. pg_database ............................................... 1901
51.16. pg_db_role_setting ........................................ 1902
51.17. pg_default_acl ............................................ 1902
51.18. pg_depend ................................................. 1903
51.19. pg_description ............................................ 1905
51.20. pg_enum ................................................... 1905
51.21. pg_event_trigger .......................................... 1906
51.22. pg_extension .............................................. 1906
51.23. pg_foreign_data_wrapper ................................... 1907
51.24. pg_foreign_server ......................................... 1907
51.25. pg_foreign_table .......................................... 1908
51.26. pg_index .................................................. 1908
51.27. pg_inherits ............................................... 1909
51.28. pg_init_privs ............................................. 1910
51.29. pg_language ............................................... 1910
51.30. pg_largeobject ............................................ 1911
51.31. pg_largeobject_metadata ................................... 1911
51.32. pg_namespace .............................................. 1912
51.33. pg_opclass ................................................ 1912
51.34. pg_operator ............................................... 1913
51.35. pg_opfamily ............................................... 1914
51.36. pg_partitioned_table ...................................... 1914
51.37. pg_policy ................................................. 1915
51.38. pg_proc ................................................... 1915
51.39. pg_publication ............................................ 1917
51.40. pg_publication_rel ........................................ 1918
51.41. pg_range .................................................. 1918
51.42. pg_replication_origin ..................................... 1919
51.43. pg_rewrite ................................................ 1919
51.44. pg_seclabel ............................................... 1920
51.45. pg_sequence ............................................... 1920
51.46. pg_shdepend ............................................... 1921
51.47. pg_shdescription .......................................... 1922
51.48. pg_shseclabel ............................................. 1922
51.49. pg_statistic .............................................. 1923
51.50. pg_statistic_ext .......................................... 1924
51.51. pg_statistic_ext_data ..................................... 1924
51.52. pg_subscription ........................................... 1925
51.53. pg_subscription_rel ....................................... 1925
51.54. pg_tablespace ............................................. 1926
51.55. pg_transform .............................................. 1926
51.56. pg_trigger ................................................ 1927
51.57. pg_ts_config .............................................. 1928
51.58. pg_ts_config_map .......................................... 1929
51.59. pg_ts_dict ................................................ 1929
51.60. pg_ts_parser .............................................. 1930
51.61. pg_ts_template ............................................ 1930
51.62. pg_type ................................................... 1931
51.63. pg_user_mapping ........................................... 1934
51.64. 系统视图 .................................................. 1934
51.65. pg_available_extensions ................................... 1935
51.66. pg_available_extension_versions ........................... 1935
xvi
PostgreSQL 13.1 手册
51.67. pg_config ................................................. 1936
51.68. pg_cursors ................................................ 1936
51.69. pg_file_settings .......................................... 1937
51.70. pg_group .................................................. 1938
51.71. pg_hba_file_rules ......................................... 1938
51.72. pg_indexes ................................................ 1939
51.73. pg_locks .................................................. 1939
51.74. pg_matviews ............................................... 1941
51.75. pg_policies ............................................... 1942
51.76. pg_prepared_statements .................................... 1942
51.77. pg_prepared_xacts ......................................... 1943
51.78. pg_publication_tables ..................................... 1943
51.79. pg_replication_origin_status .............................. 1944
51.80. pg_replication_slots ...................................... 1944
51.81. pg_roles .................................................. 1945
51.82. pg_rules .................................................. 1946
51.83. pg_seclabels .............................................. 1946
51.84. pg_sequences .............................................. 1947
51.85. pg_settings ............................................... 1948
51.86. pg_shadow ................................................. 1950
51.87. pg_shmem_allocations ...................................... 1950
51.88. pg_stats .................................................. 1951
51.89. pg_stats_ext .............................................. 1952
51.90. pg_tables ................................................. 1953
51.91. pg_timezone_abbrevs ....................................... 1953
51.92. pg_timezone_names ......................................... 1954
51.93. pg_user ................................................... 1954
51.94. pg_user_mappings .......................................... 1955
51.95. pg_views .................................................. 1955
52. 前端/后端协议 ..................................................... 1957
52.1. 概述 ....................................................... 1957
52.2. 消息流 ..................................................... 1958
52.3. SASL认证 ................................................... 1969
52.4. 流复制协议 ................................................. 1970
52.5. 逻辑流复制协议 ............................................. 1977
52.6. 消息数据类型 ............................................... 1978
52.7. 消息格式 ................................................... 1978
52.8. 错误和通知消息域 ........................................... 1994
52.9. 逻辑复制消息格式 ........................................... 1996
52.10. 自协议2.0以来的变化总结 ................................... 2000
53. PostgreSQL编码习惯 ................................................ 2002
53.1. 格式化 ..................................................... 2002
53.2. 在服务器中报告错误 ......................................... 2002
53.3. 错误消息风格指导 ........................................... 2005
53.4. 其他编码习惯 ............................................... 2009
54. 本国语言支持 ...................................................... 2011
54.1. 给翻译者 ................................................... 2011
54.2. 给编程者 ................................................... 2013
55. 编写一个过程语言处理器 ............................................ 2016
56. 编写一个外部数据包装器 ............................................ 2019
56.1. 外部数据包装器函数 ......................................... 2019
56.2. 外部数据包装器回调例程 ..................................... 2019
56.3. 外部数据包装器助手函数 ..................................... 2031
56.4. 外部数据包装器查询规划 ..................................... 2033
56.5. 外部数据包装器中的行锁定 ................................... 2034
57. 编写一种表采样方法 ................................................ 2036
57.1. 采样方法支持函数 ........................................... 2036
58. 编写一个自定义扫描提供者 .......................................... 2039
xvii
PostgreSQL 13.1 手册
58.1. 创建自定义扫描路径 ......................................... 2039
58.2. 创建自定义扫描计划 ......................................... 2040
58.3. 执行自定义扫描 ............................................. 2041
59. 遗传查询优化器 .................................................... 2044
59.1. 将查询处理看成是一个复杂的优化问题 ......................... 2044
59.2. 遗传算法 ................................................... 2044
59.3. PostgreSQL 中的遗传查询优化(GEQO) ........................ 2045
59.4. 进一步阅读 ................................................. 2046
60. 表访问方法接口定义 ................................................ 2047
61. 索引访问方法接口定义 .............................................. 2048
61.1. 索引的基本 API 结构 ....................................... 2048
61.2. 索引访问方法函数 ........................................... 2050
61.3. 索引扫描 ................................................... 2055
61.4. 索引锁定考虑 ............................................... 2056
61.5. 索引唯一性检查 ............................................. 2057
61.6. 索引开销估计函数 ........................................... 2058
62. 通用WAL 记录 ..................................................... 2061
63. B-树索引 .......................................................... 2063
63.1. 简介 ....................................................... 2063
63.2. B-树操作符类的行为 ......................................... 2063
63.3. B-树支持函数 ............................................... 2064
63.4. 实现 ....................................................... 2066
64. GiST 索引 ........................................................ 2069
64.1. 简介 ....................................................... 2069
64.2. 内建操作符类 ............................................... 2069
64.3. 可扩展性 ................................................... 2070
64.4. 实现 ....................................................... 2080
64.5. 示例 ....................................................... 2081
65. SP-GiST索引 ....................................................... 2082
65.1. 简介 ....................................................... 2082
65.2. 内建操作符类 ............................................... 2082
65.3. 可扩展性 ................................................... 2083
65.4. 实现 ....................................................... 2090
65.5. 例子 ....................................................... 2091
66. GIN 索引 ......................................................... 2092
66.1. 简介 ....................................................... 2092
66.2. 内建操作符类 ............................................... 2092
66.3. 可扩展性 ................................................... 2092
66.4. 实现 ....................................................... 2095
66.5. GIN 提示和技巧 ............................................. 2096
66.6. 限制 ....................................................... 2097
66.7. 例子 ....................................................... 2097
67. BRIN 索引 ........................................................ 2098
67.1. 简介 ....................................................... 2098
67.2. 内建操作符类 ............................................... 2098
67.3. 可扩展性 ................................................... 2099
68. 数据库物理存储 .................................................... 2103
68.1. 数据库文件布局 ............................................. 2103
68.2. TOAST ...................................................... 2105
68.3. 空闲空间映射 ............................................... 2107
68.4. 可见性映射 ................................................. 2107
68.5. 初始化分支 ................................................. 2107
68.6. 数据库页面布局 ............................................. 2108
69. 系统目录声明和初始内容 ............................................ 2111
69.1. 系统目录声明规则 ........................................... 2111
69.2. 系统目录初始数据 ........................................... 2112
69.3. BKI文件格式 ................................................ 2116
69.4. BKI命令 .................................................... 2116
xviii
PostgreSQL 13.1 手册
69.5. 自举BKI文件的结构 .......................................... 2117
69.6. BKI例子 .................................................... 2118
70. 规划器如何使用统计信息 ............................................ 2119
70.1. 行估计例子 ................................................. 2119
70.2. 多变量统计例子 ............................................. 2124
70.3. 规划器统计和安全 ........................................... 2127
71. 备份清单格式 ...................................................... 2128
71.1. 备份清单顶级(Top-level)对象 ................................ 2128
71.2. Backup Manifest File Object ............................... 2128
71.3. Backup Manifest WAL Range Object .......................... 2129
VIII. 附录 ................................................................. 2130
A. PostgreSQL错误代码 ................................................. 2136
B. 日期/时间支持 ...................................................... 2144
B.1. 日期/时间输入解释 ........................................... 2144
B.2. 处理无效或不明确的时间戳 .................................... 2145
B.3. 日期/时间关键词 ............................................. 2145
B.4. 日期/时间配置文件 ........................................... 2146
B.5. POSIX 时区规范 .............................................. 2148
B.6. 单位的历史 .................................................. 2149
C. SQL关键词 .......................................................... 2151
D. SQL 符合性 ........................................................ 2181
D.1. 已支持特性 .................................................. 2182
D.2. 未支持特性 .................................................. 2193
D.3. XML对于SQL的限制和符合性/XML ................................ 2202
E. 版本说明 ........................................................... 2205
E.1. 版本 13.1 ................................................... 2205
E.2. 发布版本 13 ................................................. 2208
E.3. 先前的版本 .................................................. 2226
F. 额外提供的模块 ..................................................... 2227
F.1. adminpack ................................................... 2227
F.2. amcheck ..................................................... 2228
F.3. auth_delay .................................................. 2231
F.4. auto_explain ................................................ 2232
F.5. bloom ....................................................... 2234
F.6. btree_gin ................................................... 2238
F.7. btree_gist .................................................. 2238
F.8. citext ...................................................... 2239
F.9. cube ........................................................ 2241
F.10. dblink ..................................................... 2245
F.11. dict_int ................................................... 2274
F.12. dict_xsyn .................................................. 2274
F.13. earthdistance .............................................. 2276
F.14. file_fdw ................................................... 2277
F.15. fuzzystrmatch .............................................. 2279
F.16. hstore ..................................................... 2282
F.17. intagg ..................................................... 2288
F.18. intarray ................................................... 2289
F.19. isn ........................................................ 2292
F.20. lo ......................................................... 2296
F.21. ltree ...................................................... 2297
F.22. pageinspect ................................................ 2303
F.23. passwordcheck .............................................. 2311
F.24. pg_buffercache ............................................. 2312
F.25. pgcrypto ................................................... 2313
F.26. pg_freespacemap ............................................ 2324
F.27. pg_prewarm ................................................. 2325
F.28. pgrowlocks ................................................. 2326
F.29. pg_stat_statements ......................................... 2327
xix
PostgreSQL 13.1 手册
F.30. pgstattuple ................................................ 2333
F.31. pg_trgm .................................................... 2337
F.32. pg_visibility .............................................. 2342
F.33. postgres_fdw ............................................... 2344
F.34. seg ........................................................ 2349
F.35. sepgsql .................................................... 2351
F.36. spi ........................................................ 2359
F.37. sslinfo .................................................... 2360
F.38. tablefunc .................................................. 2361
F.39. tcn ........................................................ 2370
F.40. test_decoding .............................................. 2371
F.41. tsm_system_rows ............................................ 2372
F.42. tsm_system_time ............................................ 2372
F.43. unaccent ................................................... 2373
F.44. uuid-ossp .................................................. 2375
F.45. xml2 ....................................................... 2376
G. 额外提供的程序 ..................................................... 2381
G.1. 客户端应用 .................................................. 2381
G.2. 服务器应用 .................................................. 2388
H. 外部项目 ........................................................... 2392
H.1. 客户端接口 .................................................. 2392
H.2. 管理工具 .................................................... 2392
H.3. 过程语言 .................................................... 2392
H.4. 扩展 ........................................................ 2393
I. 源代码仓库 ......................................................... 2394
I.1. 通过Git得到源码 ............................................. 2394
J. 文档 ............................................................... 2395
J.1. DocBook ..................................................... 2395
J.2. 工具集 ...................................................... 2395
J.3. 编译文档 .................................................... 2397
J.4. 文档创作 .................................................... 2398
J.5. 样式指导 .................................................... 2398
K. PostgreSQL限制 ..................................................... 2401
L. 首字母缩写词 ....................................................... 2402
M. 术语表 ............................................................. 2408
N. 颜色支持 ........................................................... 2419
N.1. 当使用颜色时 ................................................ 2419
N.2. 配置颜色 .................................................... 2419
参考书目 ................................................................... 2420
索引 ....................................................................... 2422
xx
剩余2484页未读,继续阅读
悟世者
- 粉丝: 5185
- 资源: 161
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
- 开源通讯录备份系统项目,易于复刻与扩展
- 探索NX二次开发:UF_DRF_ask_id_symbol_geometry函数详解
- Vuex使用教程:详细资料包解析与实践
- 汉印A300蓝牙打印机安卓App开发教程与资源
- kkFileView 4.4.0-beta版:Windows下的解压缩文件预览器
- ChatGPT对战Bard:一场AI的深度测评与比较
- 稳定版MySQL连接Java的驱动包MySQL Connector/J 5.1.38发布
- Zabbix监控系统离线安装包下载指南
- JavaScript Promise代码解析与应用
- 基于JAVA和SQL的离散数学题库管理系统开发与应用
- 竞赛项目申报系统:SpringBoot与Vue.js结合毕业设计
- JAVA+SQL打造离散数学题库管理系统:源代码与文档全览
- C#代码实现装箱与转换的详细解析
- 利用ChatGPT深入了解行业的快速方法论
- C语言链表操作实战解析与代码示例
- 大学生选修选课系统设计与实现:源码及数据库架构
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功