PostgreSQL 10.3官方文档：英文原版指南

postgresql

需积分: 15 106 浏览量更新于2024-07-19 1 收藏 15.71MB PDF 举报

身份认证购VIP最低享 7 折!

领优惠券(最高得80元）

PostgreSQL-10.3官方文档是全球PostgreSQL开发团队提供的一份详尽的技术文档，涵盖了PostgreSQL数据库的第10.3版本。作为PostgreSQL的原版英文资料，这份文档包含了丰富的功能介绍、系统架构、安装指南、SQL语言参考、管理员手册以及高级主题等全方位内容。该文档的核心要点包括： 1. **版权信息**：PostgreSQL的版权属于1996年至2018年的PostgreSQL Global Development Group，而Postgres 9.5版本的版权则归加州大学所有。文档使用须遵守版权协议，必须在所有复制材料中保留版权声明及许可条款。 2. **许可使用**：用户被允许无费用且无需书面协议地使用、复制、修改和分发此软件及其文档，但前提是保留完整的版权通知和相关条款。这意味着这是一个开源项目，遵循开源许可证，如GNU General Public License (GPL)。 3. **责任声明**：尽管文档和软件免费提供，但加州大学不对任何直接或间接损害（包括但不限于经济损失）负责，即使在事先已被告知此类损害可能性的情况下。这表明用户在使用时需自行承担风险。 4. **保修和适配声明**：加州大学明确表示不提供任何担保，包括商品质量的默示担保和特定用途的适合性担保。用户应自行评估软件是否满足其需求。 5. **内容范围**：文档内容广泛，覆盖了PostgreSQL 10.3的各个方面，从基础安装配置到高级特性，如索引管理、并发控制、存储过程、触发器、安全性设置，以及与备份恢复、性能调优和集群部署相关的详细指南。 PostgreSQL-10.3官方文档是PostgreSQL用户、开发者和管理员必备的学习和参考资源，它提供了深入理解并操作这一强大开源数据库系统的基石。对于任何希望通过PostgreSQL进行数据管理的人而言，无论是初学者还是专业人士，这份文档都是一个不可或缺的权威指南。

资源详情

资源推荐

PostgreSQL 10.3 Documentation

51.38. pg_policy .................................................................................. 1923

51.39. pg_proc ...................................................................................... 1923

51.40. pg_publication ........................................................................ 1927

51.41. pg_publication_rel ................................................................ 1928

51.42. pg_range .................................................................................... 1928

51.43. pg_replication_origin .......................................................... 1929

51.44. pg_rewrite ................................................................................ 1929

51.45. pg_seclabel .............................................................................. 1930

51.46. pg_sequence .............................................................................. 1930

51.47. pg_shdepend .............................................................................. 1931

51.48. pg_shdescription .................................................................... 1932

51.49. pg_shseclabel .......................................................................... 1933

51.50. pg_statistic ............................................................................ 1933

51.51. pg_statistic_ext .................................................................... 1935

51.52. pg_subscription ...................................................................... 1936

51.53. pg_subscription_rel .............................................................. 1937

51.54. pg_tablespace .......................................................................... 1937

51.55. pg_transform ............................................................................ 1938

51.56. pg_trigger ................................................................................ 1938

51.57. pg_ts_config ............................................................................ 1940

51.58. pg_ts_config_map .................................................................... 1941

51.59. pg_ts_dict ................................................................................ 1941

51.60. pg_ts_parser ............................................................................ 1941

51.61. pg_ts_template ........................................................................ 1942

51.62. pg_type ...................................................................................... 1942

51.63. pg_user_mapping ...................................................................... 1949

51.64. System Views ................................................................................ 1949

51.65. pg_available_extensions ...................................................... 1950

51.66. pg_available_extension_versions ...................................... 1951

51.67. pg_config .................................................................................. 1951

51.68. pg_cursors ................................................................................ 1952

51.69. pg_file_settings .................................................................... 1952

51.70. pg_group .................................................................................... 1953

51.71. pg_hba_file_rules .................................................................. 1953

51.72. pg_indexes ................................................................................ 1954

51.73. pg_locks .................................................................................... 1955

51.74. pg_matviews .............................................................................. 1957

51.75. pg_policies .............................................................................. 1958

51.76. pg_prepared_statements ........................................................ 1959

51.77. pg_prepared_xacts .................................................................. 1959

51.78. pg_publication_tables .......................................................... 1960

51.79. pg_replication_origin_status ............................................ 1960

51.80. pg_replication_slots ............................................................ 1961

51.81. pg_roles .................................................................................... 1962

51.82. pg_rules .................................................................................... 1963

51.83. pg_seclabels ............................................................................ 1964

51.84. pg_sequences ............................................................................ 1964

51.85. pg_settings .............................................................................. 1965

51.86. pg_shadow .................................................................................. 1967

51.87. pg_stats .................................................................................... 1968

51.88. pg_tables .................................................................................. 1970

51.89. pg_timezone_abbrevs .............................................................. 1971

51.90. pg_timezone_names .................................................................. 1971

51.91. pg_user ...................................................................................... 1972

51.92. pg_user_mappings .................................................................... 1972

51.93. pg_views .................................................................................... 1973

52. Frontend/Backend Protocol ........................................................................... 1974

52.1. Overview ........................................................................................ 1974

xvi

PostgreSQL 10.3 Documentation

52.2. Message Flow .................................................................................. 1975

52.3. SASL Authentication ........................................................................ 1986

52.4. Streaming Replication Protocol ........................................................... 1987

52.5. Logical Streaming Replication Protocol ................................................ 1994

52.6. Message Data Types ......................................................................... 1995

52.7. Message Formats .............................................................................. 1995

52.8. Error and Notice Message Fields ......................................................... 2012

52.9. Logical Replication Message Formats .................................................. 2014

52.10. Summary of Changes since Protocol 2.0 ............................................. 2018

53. PostgreSQL Coding Conventions ................................................................... 2019

53.1. Formatting ....................................................................................... 2019

53.2. Reporting Errors Within the Server ...................................................... 2019

53.3. Error Message Style Guide ................................................................. 2022

53.4. Miscellaneous Coding Conventions ...................................................... 2026

54. Native Language Support ............................................................................. 2028

54.1. For the Translator ............................................................................. 2028

54.2. For the Programmer .......................................................................... 2030

55. Writing A Procedural Language Handler ......................................................... 2033

56. Writing A Foreign Data Wrapper ................................................................... 2036

56.1. Foreign Data Wrapper Functions ......................................................... 2036

56.2. Foreign Data Wrapper Callback Routines .............................................. 2036

56.3. Foreign Data Wrapper Helper Functions ............................................... 2048

56.4. Foreign Data Wrapper Query Planning ................................................. 2049

56.5. Row Locking in Foreign Data Wrappers ............................................... 2051

57. Writing A Table Sampling Method ................................................................ 2053

57.1. Sampling Method Support Functions .................................................... 2053

58. Writing A Custom Scan Provider ................................................................... 2056

58.1. Creating Custom Scan Paths ............................................................... 2056

58.2. Creating Custom Scan Plans ............................................................... 2057

58.3. Executing Custom Scans .................................................................... 2058

59. Genetic Query Optimizer .............................................................................. 2060

59.1. Query Handling as a Complex Optimization Problem .............................. 2060

59.2. Genetic Algorithms ........................................................................... 2060

59.3. Genetic Query Optimization (GEQO) in PostgreSQL .............................. 2061

59.4. Further Reading ............................................................................... 2062

60. Index Access Method Interface Definition ....................................................... 2064

60.1. Basic API Structure for Indexes .......................................................... 2064

60.2. Index Access Method Functions .......................................................... 2066

60.3. Index Scanning ................................................................................ 2071

60.4. Index Locking Considerations ............................................................. 2072

60.5. Index Uniqueness Checks .................................................................. 2073

60.6. Index Cost Estimation Functions ......................................................... 2075

61. Generic WAL Records ................................................................................. 2078

62. GiST Indexes ............................................................................................. 2080

62.1. Introduction ..................................................................................... 2080

62.2. Built-in Operator Classes ................................................................... 2080

62.3. Extensibility .................................................................................... 2081

62.4. Implementation ................................................................................ 2089

62.5. Examples ........................................................................................ 2090

63. SP-GiST Indexes ........................................................................................ 2091

63.1. Introduction ..................................................................................... 2091

63.2. Built-in Operator Classes ................................................................... 2091

63.3. Extensibility .................................................................................... 2091

63.4. Implementation ................................................................................ 2099

63.5. Examples ........................................................................................ 2100

64. GIN Indexes .............................................................................................. 2101

64.1. Introduction ..................................................................................... 2101

64.2. Built-in Operator Classes ................................................................... 2101

xvii

PostgreSQL 10.3 Documentation

64.3. Extensibility .................................................................................... 2101

64.4. Implementation ................................................................................ 2104

64.5. GIN Tips and Tricks ......................................................................... 2105

64.6. Limitations ...................................................................................... 2106

64.7. Examples ........................................................................................ 2106

65. BRIN Indexes ............................................................................................ 2107

65.1. Introduction ..................................................................................... 2107

65.2. Built-in Operator Classes ................................................................... 2107

65.3. Extensibility .................................................................................... 2108

66. Database Physical Storage ............................................................................ 2112

66.1. Database File Layout ........................................................................ 2112

66.2. TOAST ........................................................................................... 2114

66.3. Free Space Map ............................................................................... 2117

66.4. Visibility Map .................................................................................. 2117

66.5. The Initialization Fork ....................................................................... 2117

66.6. Database Page Layout ....................................................................... 2118

67. BKI Backend Interface ................................................................................ 2121

67.1. BKI File Format ............................................................................... 2121

67.2. BKI Commands ............................................................................... 2121

67.3. Structure of the Bootstrap BKI File ..................................................... 2122

67.4. Example .......................................................................................... 2123

68. How the Planner Uses Statistics .................................................................... 2124

68.1. Row Estimation Examples ................................................................. 2124

68.2. Multivariate Statistics Examples .......................................................... 2129

68.3. Planner Statistics and Security ............................................................ 2131

VIII. Appendixes ...................................................................................................... 2132

A. PostgreSQL Error Codes ............................................................................... 2156

B. Date/Time Support ....................................................................................... 2165

B.1. Date/Time Input Interpretation ............................................................. 2165

B.2. Date/Time Key Words ........................................................................ 2166

B.3. Date/Time Configuration Files ............................................................. 2167

B.4. History of Units ................................................................................ 2168

C. SQL Key Words .......................................................................................... 2170

D. SQL Conformance ....................................................................................... 2193

D.1. Supported Features ............................................................................ 2194

D.2. Unsupported Features ......................................................................... 2209

E. Release Notes .............................................................................................. 2222

E.1. Release 10.3 ..................................................................................... 2222

E.2. Release 10.2 ..................................................................................... 2224

E.3. Release 10.1 ..................................................................................... 2229

E.4. Release 10 ........................................................................................ 2231

E.5. Release 9.6.8 ..................................................................................... 2252

E.6. Release 9.6.7 ..................................................................................... 2254

E.7. Release 9.6.6 ..................................................................................... 2257

E.8. Release 9.6.5 ..................................................................................... 2260

E.9. Release 9.6.4 ..................................................................................... 2262

E.10. Release 9.6.3 ................................................................................... 2267

E.11. Release 9.6.2 ................................................................................... 2272

E.12. Release 9.6.1 ................................................................................... 2277

E.13. Release 9.6 ..................................................................................... 2280

E.14. Release 9.5.12 ................................................................................. 2298

E.15. Release 9.5.11 ................................................................................. 2300

E.16. Release 9.5.10 ................................................................................. 2303

E.17. Release 9.5.9 ................................................................................... 2305

E.18. Release 9.5.8 ................................................................................... 2307

E.19. Release 9.5.7 ................................................................................... 2312

E.20. Release 9.5.6 ................................................................................... 2316

E.21. Release 9.5.5 ................................................................................... 2320

xviii

PostgreSQL 10.3 Documentation

E.22. Release 9.5.4 ................................................................................... 2324

E.23. Release 9.5.3 ................................................................................... 2328

E.24. Release 9.5.2 ................................................................................... 2330

E.25. Release 9.5.1 ................................................................................... 2333

E.26. Release 9.5 ..................................................................................... 2334

E.27. Release 9.4.17 ................................................................................. 2347

E.28. Release 9.4.16 ................................................................................. 2349

E.29. Release 9.4.15 ................................................................................. 2351

E.30. Release 9.4.14 ................................................................................. 2353

E.31. Release 9.4.13 ................................................................................. 2355

E.32. Release 9.4.12 ................................................................................. 2360

E.33. Release 9.4.11 ................................................................................. 2363

E.34. Release 9.4.10 ................................................................................. 2367

E.35. Release 9.4.9 ................................................................................... 2370

E.36. Release 9.4.8 ................................................................................... 2373

E.37. Release 9.4.7 ................................................................................... 2375

E.38. Release 9.4.6 ................................................................................... 2377

E.39. Release 9.4.5 ................................................................................... 2381

E.40. Release 9.4.4 ................................................................................... 2386

E.41. Release 9.4.3 ................................................................................... 2387

E.42. Release 9.4.2 ................................................................................... 2387

E.43. Release 9.4.1 ................................................................................... 2392

E.44. Release 9.4 ..................................................................................... 2396

E.45. Release 9.3.22 ................................................................................. 2410

E.46. Release 9.3.21 ................................................................................. 2411

E.47. Release 9.3.20 ................................................................................. 2413

E.48. Release 9.3.19 ................................................................................. 2415

E.49. Release 9.3.18 ................................................................................. 2417

E.50. Release 9.3.17 ................................................................................. 2421

E.51. Release 9.3.16 ................................................................................. 2424

E.52. Release 9.3.15 ................................................................................. 2427

E.53. Release 9.3.14 ................................................................................. 2429

E.54. Release 9.3.13 ................................................................................. 2432

E.55. Release 9.3.12 ................................................................................. 2434

E.56. Release 9.3.11 ................................................................................. 2435

E.57. Release 9.3.10 ................................................................................. 2439

E.58. Release 9.3.9 ................................................................................... 2443

E.59. Release 9.3.8 ................................................................................... 2444

E.60. Release 9.3.7 ................................................................................... 2445

E.61. Release 9.3.6 ................................................................................... 2449

E.62. Release 9.3.5 ................................................................................... 2457

E.63. Release 9.3.4 ................................................................................... 2461

E.64. Release 9.3.3 ................................................................................... 2463

E.65. Release 9.3.2 ................................................................................... 2469

E.66. Release 9.3.1 ................................................................................... 2472

E.67. Release 9.3 ..................................................................................... 2473

E.68. Release 9.2.24 ................................................................................. 2485

E.69. Release 9.2.23 ................................................................................. 2486

E.70. Release 9.2.22 ................................................................................. 2488

E.71. Release 9.2.21 ................................................................................. 2491

E.72. Release 9.2.20 ................................................................................. 2494

E.73. Release 9.2.19 ................................................................................. 2497

E.74. Release 9.2.18 ................................................................................. 2498

E.75. Release 9.2.17 ................................................................................. 2501

E.76. Release 9.2.16 ................................................................................. 2502

E.77. Release 9.2.15 ................................................................................. 2503

E.78. Release 9.2.14 ................................................................................. 2507

E.79. Release 9.2.13 ................................................................................. 2511

xix

PostgreSQL 10.3 Documentation

E.80. Release 9.2.12 ................................................................................. 2511

E.81. Release 9.2.11 ................................................................................. 2512

E.82. Release 9.2.10 ................................................................................. 2516

E.83. Release 9.2.9 ................................................................................... 2522

E.84. Release 9.2.8 ................................................................................... 2525

E.85. Release 9.2.7 ................................................................................... 2527

E.86. Release 9.2.6 ................................................................................... 2531

E.87. Release 9.2.5 ................................................................................... 2533

E.88. Release 9.2.4 ................................................................................... 2536

E.89. Release 9.2.3 ................................................................................... 2538

E.90. Release 9.2.2 ................................................................................... 2541

E.91. Release 9.2.1 ................................................................................... 2546

E.92. Release 9.2 ..................................................................................... 2547

E.93. Release 9.1.24 ................................................................................. 2564

E.94. Release 9.1.23 ................................................................................. 2565

E.95. Release 9.1.22 ................................................................................. 2568

E.96. Release 9.1.21 ................................................................................. 2569

E.97. Release 9.1.20 ................................................................................. 2570

E.98. Release 9.1.19 ................................................................................. 2573

E.99. Release 9.1.18 ................................................................................. 2577

E.100. Release 9.1.17 ................................................................................ 2577

E.101. Release 9.1.16 ................................................................................ 2578

E.102. Release 9.1.15 ................................................................................ 2582

E.103. Release 9.1.14 ................................................................................ 2587

E.104. Release 9.1.13 ................................................................................ 2590

E.105. Release 9.1.12 ................................................................................ 2591

E.106. Release 9.1.11 ................................................................................ 2595

E.107. Release 9.1.10 ................................................................................ 2596

E.108. Release 9.1.9 ................................................................................. 2598

E.109. Release 9.1.8 ................................................................................. 2601

E.110. Release 9.1.7 ................................................................................. 2603

E.111. Release 9.1.6 ................................................................................. 2606

E.112. Release 9.1.5 ................................................................................. 2607

E.113. Release 9.1.4 ................................................................................. 2610

E.114. Release 9.1.3 ................................................................................. 2613

E.115. Release 9.1.2 ................................................................................. 2617

E.116. Release 9.1.1 ................................................................................. 2622

E.117. Release 9.1 .................................................................................... 2622

E.118. Release 9.0.23 ................................................................................ 2639

E.119. Release 9.0.22 ................................................................................ 2642

E.120. Release 9.0.21 ................................................................................ 2642

E.121. Release 9.0.20 ................................................................................ 2643

E.122. Release 9.0.19 ................................................................................ 2646

E.123. Release 9.0.18 ................................................................................ 2651

E.124. Release 9.0.17 ................................................................................ 2654

E.125. Release 9.0.16 ................................................................................ 2655

E.126. Release 9.0.15 ................................................................................ 2658

E.127. Release 9.0.14 ................................................................................ 2660

E.128. Release 9.0.13 ................................................................................ 2662

E.129. Release 9.0.12 ................................................................................ 2664

E.130. Release 9.0.11 ................................................................................ 2665

E.131. Release 9.0.10 ................................................................................ 2668

E.132. Release 9.0.9 ................................................................................. 2669

E.133. Release 9.0.8 ................................................................................. 2671

E.134. Release 9.0.7 ................................................................................. 2673

E.135. Release 9.0.6 ................................................................................. 2677

E.136. Release 9.0.5 ................................................................................. 2679

E.137. Release 9.0.4 ................................................................................. 2683

剩余3331页未读，继续阅读

weibin_2017

粉丝: 0
资源: 1

PostgreSQL 10.3官方文档：英文原版指南

postgresql 中文手册

PostgreSQL 10.1中文手册.pdf

PostgreSQL手册

postgresql-10.15

E: Unable to locate package postgresql-14

postgresql-9.0下载

postgresql jdbc官方文档

PostgreSQL 单机 基于centos docker镜像制作

postgresql-大坑

docker基于centos离线制作postgresql镜像

postgresql 11.2中文手册下载

Job for postgresql@15-main.service failed because the service did not take the steps required by its unit configuration. See "systemctl status postgresql@15-main.service" and "journalctl -xeu postgresql@15-main.service" for details.

PostgreSQL官方文档

postgresql13安装postgis

pytest-postgresql 怎么用

postgresql安装教程2024

postgresql14.4安装

postgresql在Linux下载

postgresql13安装乌班图

Failed to start postgresql.service: Unit not found.

最新资源

PostgreSQL 单机基于centos docker镜像制作