PostgreSQL 官方文档完全手册：SQL、管理与运维
首页 白天 夜间 BookChat 小程序 小程序 下载 阅读记录
  • 书签 我的书签
  • 添加书签 添加书签 移除书签 移除书签

首字母 P – S

来源 PostgreSQL Global Development Group 浏览 3 扫码 打印 2026-10-27 12:50:39
  • Part VI. Reference
  • Part VII. Internals
  • Part VIII. Appendixes
  • PostgreSQL 18.6 Documentation
  • PostgreSQL Client Applications
  • PostgreSQL Server Applications
  • Preface
  • SQL Commands
上一篇:
下一篇:
  • 书签
  • 添加书签 移除书签
  • 首字母 1 – 1
    • 1. What Is PostgreSQL ? #
    • 15.4. Parallel Safety #
    • 17.1. Requirements #
    • 17.2. Getting the Source #
    • 17.3. Building and Installation with Autoconf and Make #
    • 17.4. Building and Installation with Meson #
    • 17.5. Post-Installation Setup #
    • 17.6. Supported Platforms #
    • 17.7. Platform-Specific Notes #
    • 18.1. The PostgreSQL User Account #
    • 18.10. Secure TCP/IP Connections with GSSAPI Encryption #
    • 18.11. Secure TCP/IP Connections with SSH Tunnels #
    • 18.12. Registering Event Log on Windows #
    • 18.2. Creating a Database Cluster #
    • 18.3. Starting the Database Server #
    • 18.4. Managing Kernel Resources #
    • 18.5. Shutting Down the Server #
    • 18.6. Upgrading a PostgreSQL Cluster #
    • 18.7. Preventing Server Spoofing #
    • 18.8. Encryption Options #
    • 18.9. Secure TCP/IP Connections with SSL #
    • 19.1. Setting Parameters #
  • 首字母 1 – 2
    • 19.10. Vacuuming #
    • 19.11. Client Connection Defaults #
    • 19.12. Lock Management #
    • 19.13. Version and Platform Compatibility #
    • 19.14. Error Handling #
    • 19.15. Preset Options #
    • 19.16. Customized Options #
    • 19.17. Developer Options #
    • 19.18. Short Options #
    • 19.2. File Locations #
    • 19.3. Connections and Authentication #
    • 19.4. Resource Consumption #
    • 19.5. Write Ahead Log #
    • 19.6. Replication #
    • 19.7. Query Planning #
    • 19.8. Error Reporting and Logging #
    • 19.9. Run-time Statistics #
    • 2. A Brief History of PostgreSQL #
    • 20.1. The pg_hba.conf File #
    • 20.10. LDAP Authentication #
    • 20.11. RADIUS Authentication #
    • 20.12. Certificate Authentication #
  • 首字母 2 – 2
    • 20.13. PAM Authentication #
    • 20.14. BSD Authentication #
    • 20.15. OAuth Authorization/Authentication #
    • 20.16. Authentication Problems #
    • 20.2. User Name Maps #
    • 20.3. Authentication Methods #
    • 20.4. Trust Authentication #
    • 20.5. Password Authentication #
    • 20.6. GSSAPI Authentication #
    • 20.7. SSPI Authentication #
    • 20.8. Ident Authentication #
    • 20.9. Peer Authentication #
    • 21.1. Database Roles #
    • 21.2. Role Attributes #
    • 21.3. Role Membership #
    • 21.4. Dropping Roles #
    • 21.5. Predefined Roles #
    • 21.6. Function Security #
    • 22.1. Overview #
    • 22.2. Creating a Database #
    • 22.3. Template Databases #
    • 22.4. Database Configuration #
  • 首字母 2 – 2（2）
    • 22.5. Destroying a Database #
    • 22.6. Tablespaces #
    • 23.1. Locale Support #
    • 23.2. Collation Support #
    • 23.3. Character Set Support #
    • 24.1. Routine Vacuuming #
    • 24.3. Log File Maintenance #
    • 25.1. SQL Dump #
    • 25.2. File System Level Backup #
    • 25.3. Continuous Archiving and Point-in-Time Recovery (PITR) #
    • 26.1. Comparison of Different Solutions #
    • 26.2. Log-Shipping Standby Servers #
    • 26.3. Failover #
    • 26.4. Hot Standby #
    • 27.1. Standard Unix Tools #
    • 27.2. The Cumulative Statistics System #
    • 27.3. Viewing Locks #
    • 27.4. Progress Reporting #
    • 27.5. Dynamic Tracing #
    • 27.6. Monitoring Disk Usage #
    • 28.1. Reliability #
    • 28.2. Data Checksums #
  • 首字母 2 – 3
    • 28.3. Write-Ahead Logging ( WAL ) #
    • 28.4. Asynchronous Commit #
    • 28.5. WAL Configuration #
    • 28.6. WAL Internals #
    • 29.1. Publication #
    • 29.10. Monitoring #
    • 29.11. Security #
    • 29.12. Configuration Settings #
    • 29.13. Upgrade #
    • 29.14. Quick Setup #
    • 29.2. Subscription #
    • 29.3. Logical Replication Failover #
    • 29.4. Row Filters #
    • 29.5. Column Lists #
    • 29.6. Generated Column Replication #
    • 29.7. Conflicts #
    • 29.8. Restrictions #
    • 29.9. Architecture #
    • 3. Conventions #
    • 30.1. What Is JIT compilation? #
    • 30.2. When to JIT ? #
    • 30.3. Configuration #
  • 首字母 3 – A
    • 30.4. Extensibility #
    • 31.1. Running the Tests #
    • 31.2. Test Evaluation #
    • 31.3. Variant Comparison Files #
    • 31.4. TAP Tests #
    • 31.5. Test Coverage Examination #
    • 36.10. C-Language Functions #
    • 36.18. Extension Building Infrastructure #
    • 4. Further Information #
    • 5. Bug Reporting Guidelines #
    • 65.2. GiST Indexes #
    • 65.3. SP-GiST Indexes #
    • 65.4. GIN Indexes #
    • 66.2. TOAST #
    • 66.3. Free Space Map #
    • 66.7. Heap-Only Tuples ( HOT ) #
    • 7.8. WITH Queries (Common Table Expressions) #
    • 70.3. Backup Manifest WAL Range Object #
    • 8.12. UUID Type #
    • 8.19. Object Identifier Types #
    • Appendix A. PostgreSQL Error Codes
    • Appendix B. Date/Time Support
  • 首字母 A – C
    • Appendix C. SQL Key Words
    • Appendix D. SQL Conformance
    • Appendix E. Release Notes
    • Appendix F. Additional Supplied Modules and Extensions
    • Appendix G. Additional Supplied Programs
    • Appendix H. External Projects
    • Appendix I. The Source Code Repository
    • Appendix J. Documentation
    • Appendix K. PostgreSQL Limits
    • Appendix L. Acronyms
    • Appendix M. Glossary
    • Appendix N. Color Support
    • Appendix O. Obsolete or Renamed Features
    • B.1. Date/Time Input Interpretation #
    • B.2. Handling of Invalid or Ambiguous Timestamps #
    • B.4. Date/Time Configuration Files #
    • B.7. Julian Dates #
    • Bibliography
    • Chapter 1. Getting Started
    • Chapter 10. Type Conversion
    • Chapter 11. Indexes
    • Chapter 13. Concurrency Control
  • 首字母 C – C
    • Chapter 14. Performance Tips
    • Chapter 15. Parallel Query
    • Chapter 16. Installation from Binaries
    • Chapter 17. Installation from Source Code
    • Chapter 18. Server Setup and Operation
    • Chapter 19. Server Configuration
    • Chapter 2. The SQL Language
    • Chapter 20. Client Authentication
    • Chapter 21. Database Roles
    • Chapter 22. Managing Databases
    • Chapter 23. Localization
    • Chapter 24. Routine Database Maintenance Tasks
    • Chapter 25. Backup and Restore
    • Chapter 26. High Availability, Load Balancing, and Replication
    • Chapter 27. Monitoring Database Activity
    • Chapter 28. Reliability and the Write-Ahead Log
    • Chapter 29. Logical Replication
    • Chapter 3. Advanced Features
    • Chapter 30. Just-in-Time Compilation ( JIT )
    • Chapter 31. Regression Tests
    • Chapter 32. libpq — C Library
    • Chapter 33. Large Objects
  • 首字母 C – C（2）
    • Chapter 34. ECPG — Embedded SQL in C
    • Chapter 35. The Information Schema
    • Chapter 36. Extending SQL
    • Chapter 37. Triggers
    • Chapter 38. Event Triggers
    • Chapter 39. The Rule System
    • Chapter 4. SQL Syntax
    • Chapter 40. Procedural Languages
    • Chapter 41. PL/pgSQL — SQL Procedural Language
    • Chapter 42. PL/Tcl — Tcl Procedural Language
    • Chapter 43. PL/Perl — Perl Procedural Language
    • Chapter 44. PL/Python — Python Procedural Language
    • Chapter 45. Server Programming Interface
    • Chapter 46. Background Worker Processes
    • Chapter 47. Logical Decoding
    • Chapter 48. Replication Progress Tracking
    • Chapter 5. Data Definition
    • Chapter 50. OAuth Validator Modules
    • Chapter 51. Overview of PostgreSQL Internals
    • Chapter 52. System Catalogs
    • Chapter 53. System Views
    • Chapter 54. Frontend/Backend Protocol
  • 首字母 C – F
    • Chapter 55. PostgreSQL Coding Conventions
    • Chapter 56. Native Language Support
    • Chapter 57. Writing a Procedural Language Handler
    • Chapter 58. Writing a Foreign Data Wrapper
    • Chapter 59. Writing a Table Sampling Method
    • Chapter 6. Data Manipulation
    • Chapter 60. Writing a Custom Scan Provider
    • Chapter 61. Genetic Query Optimizer
    • Chapter 62. Table Access Method Interface Definition
    • Chapter 63. Index Access Method Interface Definition
    • Chapter 64. Write Ahead Logging for Extensions
    • Chapter 65. Built-in Index Access Methods
    • Chapter 66. Database Physical Storage
    • Chapter 67. Transaction Processing
    • Chapter 68. System Catalog Declarations and Initial Contents
    • Chapter 69. How the Planner Uses Statistics
    • Chapter 7. Queries
    • Chapter 70. Backup Manifest Format
    • Chapter 8. Data Types
    • Chapter 9. Functions and Operators
    • F.1. amcheck — tools to verify table and index consistency #
    • F.10. cube — a multi-dimensional cube data type #
  • 首字母 F – P
    • F.2. auth_delay — pause on authentication failure #
    • F.3. auto_explain — log execution plans of slow queries #
    • F.4. basebackup_to_shell — example "shell" pg_basebackup module #
    • F.41. spi — Server Programming Interface features/examples #
    • F.6. bloom — bloom filter index access method #
    • F.7. btree_gin — GIN operator classes with B-tree behavior #
    • F.8. btree_gist — GiST operator classes with B-tree behavior #
    • F.9. citext — a case-insensitive character string type #
    • G.1. Client Applications #
    • G.2. Server Applications #
    • N.1. When Color is Used #
    • N.2. Configuring the Colors #
    • O.1. recovery.conf file merged into postgresql.conf #
    • O.2. Default Roles Renamed to Predefined Roles #
    • O.3. pg_xlogdump renamed to pg_waldump #
    • O.4. pg_resetxlog renamed to pg_resetwal #
    • O.5. pg_receivexlog renamed to pg_receivewal #
    • Part I. Tutorial
    • Part II. The SQL Language
    • Part III. Server Administration
    • Part IV. Client Interfaces
    • Part V. Server Programming
  • 首字母 P – S
    • Part VI. Reference
    • Part VII. Internals
    • Part VIII. Appendixes
    • PostgreSQL 18.6 Documentation
    • PostgreSQL Client Applications
    • PostgreSQL Server Applications
    • Preface
    • SQL Commands
暂无相关搜索结果！

    本文档使用 WanXiangYunDang 构建

    展开/收起文章目录

    思维导图备注

    文章二维码

    手机扫一扫，轻松掌上读

    文档下载

    请下载您需要的格式的文档，随时随地，享受汲取知识的乐趣！
    PDF文档 EPUB文档 MOBI文档

    微信小程序阅读

    BookChat 微信小程序阅读
    微信扫一扫，知识掌上学

    书签列表

      阅读记录

      阅读进度: 0.00% ( 0/0 ) 重置阅读进度