PostgreSQL 15.1 Documentation
- 1. Legal Notice
- 2. Preface
- 3. Tutorial
- 4. The SQL Language
- 4.1. SQL Syntax
- 4.2. Data Definition
- 4.2.1. Table Basics
- 4.2.2. Default Values
- 4.2.3. Generated Columns
- 4.2.4. Constraints
- 4.2.5. System Columns
- 4.2.6. Modifying Tables
- 4.2.7. Privileges
- 4.2.8. Row Security Policies
- 4.2.9. Schemas
- 4.2.10. Inheritance
- 4.2.11. Table Partitioning
- 4.2.12. Foreign Data
- 4.2.13. Other Database Objects
- 4.2.14. Dependency Tracking
- 4.3. Data Manipulation
- 4.4. Queries
- 4.5. Data Types
- 4.5.1. Numeric Types
- 4.5.2. Monetary Types
- 4.5.3. Character Types
- 4.5.4. Binary Data Types
- 4.5.5. Date/Time Types
- 4.5.6. Boolean Type
- 4.5.7. Enumerated Types
- 4.5.8. Geometric Types
- 4.5.9. Network Address Types
- 4.5.10. Bit String Types
- 4.5.11. Text Search Types
- 4.5.12. UUID Type
- 4.5.13. XML Type
- 4.5.14. Domain Types
- 4.5.15. Object Identifier Types
- 4.5.16. pg_lsn Type
- 4.5.17. Pseudo-Types
- 4.6. Functions and Operators
- 4.6.1. Logical Operators
- 4.6.2. Comparison Functions and Operators
- 4.6.3. Mathematical Functions and Operators
- 4.6.4. String Functions and Operators
- 4.6.5. Binary String Functions and Operators
- 4.6.6. Bit String Functions and Operators
- 4.6.7. Pattern Matching
- 4.6.8. Data Type Formatting Functions
- 4.6.9. Date/Time Functions and Operators
- 4.6.10. Enum Support Functions
- 4.6.11. Geometric Functions and Operators
- 4.6.12. Network Address Functions and Operators
- 4.6.13. Text Search Functions and Operators
- 4.6.14. UUID Functions
- 4.6.15. XML Functions
- 4.6.16. JSON Functions and Operators
- 4.6.17. Sequence Manipulation Functions
- 4.6.18. Conditional Expressions
- 4.6.19. Array Functions and Operators
- 4.6.20. Range/Multirange Functions and Operators
- 4.6.21. Aggregate Functions
- 4.6.22. Window Functions
- 4.6.23. Subquery Expressions
- 4.6.24. Row and Array Comparisons
- 4.6.25. Set Returning Functions
- 4.6.26. System Information Functions and Operators
- 4.6.27. System Administration Functions
- 4.6.28. Trigger Functions
- 4.6.29. Event Trigger Functions
- 4.6.30. Statistics Information Functions
- 4.7. Type Conversion
- 4.8. Indexes
- 4.8.1. Introduction
- 4.8.2. Index Types
- 4.8.3. Multicolumn Indexes
- 4.8.4. Indexes and ORDER BY
- 4.8.5. Combining Multiple Indexes
- 4.8.6. Unique Indexes
- 4.8.7. Indexes on Expressions
- 4.8.8. Partial Indexes
- 4.8.9. Index-Only Scans and Covering Indexes
- 4.8.10. Operator Classes and Operator Families
- 4.8.11. Indexes and Collations
- 4.8.12. Examining Index Usage
- 4.9. Full Text Search
- 4.10. Concurrency Control
- 4.11. Performance Tips
- 4.12. Parallel Query
- 5. Server Administration
- 5.1. Installation from Source Code
- 5.2. Server Setup and Operation
- 5.2.1. The PostgreSQL User Account
- 5.2.2. Creating a Database Cluster
- 5.2.3. Starting the Database Server
- 5.2.4. Managing Kernel Resources
- 5.2.5. Shutting Down the Server
- 5.2.6. Upgrading a PostgreSQL Cluster
- 5.2.7. Preventing Server Spoofing
- 5.2.8. Encryption Options
- 5.2.9. Secure TCP/IP Connections with SSL
- 5.2.10. Secure TCP/IP Connections with GSSAPI Encryption
- 5.2.11. Secure TCP/IP Connections with SSH Tunnels
- 5.2.12. Registering Event Log on Windows
- 5.3. Server Configuration
- 5.3.1. Setting Parameters
- 5.3.2. File Locations
- 5.3.3. Connections and Authentication
- 5.3.4. Resource Consumption
- 5.3.5. Write Ahead Log
- 5.3.6. Replication
- 5.3.7. Query Planning
- 5.3.8. Error Reporting and Logging
- 5.3.9. Run-time Statistics
- 5.3.10. Automatic Vacuuming
- 5.3.11. Client Connection Defaults
- 5.3.12. Lock Management
- 5.3.13. Version and Platform Compatibility
- 5.3.14. Error Handling
- 5.3.15. Preset Options
- 5.3.16. Customized Options
- 5.3.17. Developer Options
- 5.3.18. Short Options
- 5.4. Client Authentication
- 5.4.1. The pg_hba.conf File
- 5.4.2. User Name Maps
- 5.4.3. Authentication Methods
- 5.4.4. Trust Authentication
- 5.4.5. Password Authentication
- 5.4.6. GSSAPI Authentication
- 5.4.7. SSPI Authentication
- 5.4.8. Ident Authentication
- 5.4.9. Peer Authentication
- 5.4.10. LDAP Authentication
- 5.4.11. RADIUS Authentication
- 5.4.12. Certificate Authentication
- 5.4.13. PAM Authentication
- 5.4.14. BSD Authentication
- 5.4.15. Authentication Problems
- 5.5. Database Roles
- 5.6. Managing Databases
- 5.7. Localization
- 5.8. Routine Database Maintenance Tasks
- 5.9. Backup and Restore
- 5.10. High Availability, Load Balancing, and Replication
- 5.11. Monitoring Database Activity
- 5.12. Monitoring Disk Usage
- 5.13. Reliability and the Write-Ahead Log
- 5.14. Logical Replication
- 5.15. Just-in-Time Compilation (JIT)
- 5.16. Regression Tests
- 6. Client Interfaces
- 6.1. libpq — C Library
- 6.1.1. Database Connection Control Functions
- 6.1.2. Connection Status Functions
- 6.1.3. Command Execution Functions
- 6.1.4. Asynchronous Command Processing
- 6.1.5. Pipeline Mode
- 6.1.6. Retrieving Query Results Row-by-Row
- 6.1.7. Canceling Queries in Progress
- 6.1.8. The Fast-Path Interface
- 6.1.9. Asynchronous Notification
- 6.1.10. Functions Associated with the COPY Command
- 6.1.11. Control Functions
- 6.1.12. Miscellaneous Functions
- 6.1.13. Notice Processing
- 6.1.14. Event System
- 6.1.15. Environment Variables
- 6.1.16. The Password File
- 6.1.17. The Connection Service File
- 6.1.18. LDAP Lookup of Connection Parameters
- 6.1.19. SSL Support
- 6.1.20. Behavior in Threaded Programs
- 6.1.21. Building libpq Programs
- 6.1.22. Example Programs
- 6.2. Large Objects
- 6.3. ECPG — Embedded SQL in C
- 6.3.1. The Concept
- 6.3.2. Managing Database Connections
- 6.3.3. Running SQL Commands
- 6.3.4. Using Host Variables
- 6.3.5. Dynamic SQL
- 6.3.6. pgtypes Library
- 6.3.7. Using Descriptor Areas
- 6.3.8. Error Handling
- 6.3.9. Preprocessor Directives
- 6.3.10. Processing Embedded SQL Programs
- 6.3.11. Library Functions
- 6.3.12. Large Objects
- 6.3.13. C++ Applications
- 6.3.14. Embedded SQL Commands
- 6.3.15. Description
- 6.3.16. Parameters
- 6.3.17. Examples
- 6.3.18. Compatibility
- 6.3.19. See Also
- 6.3.20. Description
- 6.3.21. Parameters
- 6.3.22. Examples
- 6.3.23. Compatibility
- 6.3.24. See Also
- 6.3.25. Description
- 6.3.26. Parameters
- 6.3.27. Examples
- 6.3.28. Compatibility
- 6.3.29. See Also
- 6.3.30. Description
- 6.3.31. Parameters
- 6.3.32. Examples
- 6.3.33. Compatibility
- 6.3.34. See Also
- 6.3.35. Description
- 6.3.36. Parameters
- 6.3.37. Notes
- 6.3.38. Examples
- 6.3.39. Compatibility
- 6.3.40. See Also
- 6.3.41. Description
- 6.3.42. Parameters
- 6.3.43. Examples
- 6.3.44. Compatibility
- 6.3.45. See Also
- 6.3.46. Description
- 6.3.47. Parameters
- 6.3.48. Examples
- 6.3.49. Compatibility
- 6.3.50. See Also
- 6.3.51. Description
- 6.3.52. Parameters
- 6.3.53. Notes
- 6.3.54. Examples
- 6.3.55. Compatibility
- 6.3.56. Description
- 6.3.57. Parameters
- 6.3.58. Examples
- 6.3.59. Compatibility
- 6.3.60. See Also
- 6.3.61. Description
- 6.3.62. Parameters
- 6.3.63. Examples
- 6.3.64. Compatibility
- 6.3.65. See Also
- 6.3.66. Description
- 6.3.67. Parameters
- 6.3.68. Notes
- 6.3.69. Examples
- 6.3.70. Compatibility
- 6.3.71. See Also
- 6.3.72. Description
- 6.3.73. Compatibility
- 6.3.74. Description
- 6.3.75. Parameters
- 6.3.76. Examples
- 6.3.77. Compatibility
- 6.3.78. See Also
- 6.3.79. Description
- 6.3.80. Parameters
- 6.3.81. Examples
- 6.3.82. Compatibility
- 6.3.83. See Also
- 6.3.84. Description
- 6.3.85. Parameters
- 6.3.86. Examples
- 6.3.87. Compatibility
- 6.3.88. Description
- 6.3.89. Parameters
- 6.3.90. Examples
- 6.3.91. Compatibility
- 6.3.92. Description
- 6.3.93. Parameters
- 6.3.94. Examples
- 6.3.95. Compatibility
- 6.3.96. Informix Compatibility Mode
- 6.3.97. Oracle Compatibility Mode
- 6.3.98. Internals
- 6.1. libpq — C Library
- 7. Server Programming
- 7.1. Extending SQL
- 7.2. Triggers
- 7.3. Event Triggers
- 7.4. The Rule System
- 7.5. Procedural Languages
- 7.6. PL/Tcl — Tcl Procedural Language
- 7.6.1. Overview
- 7.6.2. PL/Tcl Functions and Arguments
- 7.6.3. Data Values in PL/Tcl
- 7.6.4. Global Data in PL/Tcl
- 7.6.5. Database Access from PL/Tcl
- 7.6.6. Trigger Functions in PL/Tcl
- 7.6.7. Event Trigger Functions in PL/Tcl
- 7.6.8. Error Handling in PL/Tcl
- 7.6.9. Explicit Subtransactions in PL/Tcl
- 7.6.10. Transaction Management
- 7.6.11. PL/Tcl Configuration
- 7.6.12. Tcl Procedure Names
- 7.7. PL/Perl — Perl Procedural Language
- 7.8. PL/Python — Python Procedural Language
- 7.9. Server Programming Interface
- 7.9.1. Interface Functions
- 7.9.2. Description
- 7.9.3. Return Value
- 7.9.4. Description
- 7.9.5. Return Value
- 7.9.6. Description
- 7.9.7. Arguments
- 7.9.8. Return Value
- 7.9.9. Notes
- 7.9.10. Description
- 7.9.11. Arguments
- 7.9.12. Return Value
- 7.9.13. Description
- 7.9.14. Arguments
- 7.9.15. Return Value
- 7.9.16. Description
- 7.9.17. Arguments
- 7.9.18. Return Value
- 7.9.19. Description
- 7.9.20. Arguments
- 7.9.21. Return Value
- 7.9.22. Notes
- 7.9.23. Description
- 7.9.24. Arguments
- 7.9.25. Return Value
- 7.9.26. Notes
- 7.9.27. Description
- 7.9.28. Arguments
- 7.9.29. Return Value
- 7.9.30. Description
- 7.9.31. Arguments
- 7.9.32. Return Value
- 7.9.33. Description
- 7.9.34. Arguments
- 7.9.35. Return Value
- 7.9.36. Description
- 7.9.37. Arguments
- 7.9.38. Return Value
- 7.9.39. Description
- 7.9.40. Arguments
- 7.9.41. Return Value
- 7.9.42. Description
- 7.9.43. Arguments
- 7.9.44. Return Value
- 7.9.45. Description
- 7.9.46. Arguments
- 7.9.47. Return Value
- 7.9.48. Description
- 7.9.49. Arguments
- 7.9.50. Return Value
- 7.9.51. Description
- 7.9.52. Arguments
- 7.9.53. Return Value
- 7.9.54. Description
- 7.9.55. Arguments
- 7.9.56. Return Value
- 7.9.57. Description
- 7.9.58. Arguments
- 7.9.59. Return Value
- 7.9.60. Description
- 7.9.61. Arguments
- 7.9.62. Return Value
- 7.9.63. Description
- 7.9.64. Arguments
- 7.9.65. Return Value
- 7.9.66. Description
- 7.9.67. Arguments
- 7.9.68. Return Value
- 7.9.69. Description
- 7.9.70. Arguments
- 7.9.71. Return Value
- 7.9.72. Notes
- 7.9.73. Description
- 7.9.74. Arguments
- 7.9.75. Notes
- 7.9.76. Description
- 7.9.77. Arguments
- 7.9.78. Return Value
- 7.9.79. Notes
- 7.9.80. Description
- 7.9.81. Arguments
- 7.9.82. Return Value
- 7.9.83. Notes
- 7.9.84. Description
- 7.9.85. Arguments
- 7.9.86. Description
- 7.9.87. Arguments
- 7.9.88. Return Value
- 7.9.89. Notes
- 7.9.90. Description
- 7.9.91. Arguments
- 7.9.92. Return Value
- 7.9.93. Notes
- 7.9.94. Description
- 7.9.95. Arguments
- 7.9.96. Return Value
- 7.9.97. Description
- 7.9.98. Arguments
- 7.9.99. Return Value
- 7.9.100. Description
- 7.9.101. Arguments
- 7.9.102. Return Value
- 7.9.103. Interface Support Functions
- 7.9.104. Description
- 7.9.105. Arguments
- 7.9.106. Return Value
- 7.9.107. Description
- 7.9.108. Arguments
- 7.9.109. Return Value
- 7.9.110. Description
- 7.9.111. Arguments
- 7.9.112. Return Value
- 7.9.113. Description
- 7.9.114. Arguments
- 7.9.115. Return Value
- 7.9.116. Description
- 7.9.117. Arguments
- 7.9.118. Return Value
- 7.9.119. Description
- 7.9.120. Arguments
- 7.9.121. Return Value
- 7.9.122. Description
- 7.9.123. Arguments
- 7.9.124. Return Value
- 7.9.125. Description
- 7.9.126. Arguments
- 7.9.127. Return Value
- 7.9.128. Description
- 7.9.129. Arguments
- 7.9.130. Return Value
- 7.9.131. Memory Management
- 7.9.132. Description
- 7.9.133. Arguments
- 7.9.134. Return Value
- 7.9.135. Description
- 7.9.136. Arguments
- 7.9.137. Return Value
- 7.9.138. Description
- 7.9.139. Arguments
- 7.9.140. Description
- 7.9.141. Arguments
- 7.9.142. Return Value
- 7.9.143. Description
- 7.9.144. Arguments
- 7.9.145. Return Value
- 7.9.146. Description
- 7.9.147. Arguments
- 7.9.148. Return Value
- 7.9.149. Description
- 7.9.150. Arguments
- 7.9.151. Description
- 7.9.152. Arguments
- 7.9.153. Description
- 7.9.154. Arguments
- 7.9.155. Return Value
- 7.9.156. Transaction Management
- 7.9.157. Description
- 7.9.158. Description
- 7.9.159. Description
- 7.9.160. Visibility of Data Changes
- 7.9.161. Examples
- 7.10. Background Worker Processes
- 7.11. Logical Decoding
- 7.11.1. Logical Decoding Examples
- 7.11.2. Logical Decoding Concepts
- 7.11.3. Streaming Replication Protocol Interface
- 7.11.4. Logical Decoding SQL Interface
- 7.11.5. System Catalogs Related to Logical Decoding
- 7.11.6. Logical Decoding Output Plugins
- 7.11.7. Logical Decoding Output Writers
- 7.11.8. Synchronous Replication Support for Logical Decoding
- 7.11.9. Streaming of Large Transactions for Logical Decoding
- 7.11.10. Two-phase Commit Support for Logical Decoding
- 7.12. Replication Progress Tracking
- 7.13. Archive Modules
- 8. Reference
- 9. Internals
- 9.1. Overview of PostgreSQL Internals
- 9.2. System Catalogs
- 9.2.1. Overview
- 9.2.2. pg_aggregate
- 9.2.3. pg_am
- 9.2.4. pg_amop
- 9.2.5. pg_amproc
- 9.2.6. pg_attrdef
- 9.2.7. pg_attribute
- 9.2.8. pg_authid
- 9.2.9. pg_auth_members
- 9.2.10. pg_cast
- 9.2.11. pg_class
- 9.2.12. pg_collation
- 9.2.13. pg_constraint
- 9.2.14. pg_conversion
- 9.2.15. pg_database
- 9.2.16. pg_db_role_setting
- 9.2.17. pg_default_acl
- 9.2.18. pg_depend
- 9.2.19. pg_description
- 9.2.20. pg_enum
- 9.2.21. pg_event_trigger
- 9.2.22. pg_extension
- 9.2.23. pg_foreign_data_wrapper
- 9.2.24. pg_foreign_server
- 9.2.25. pg_foreign_table
- 9.2.26. pg_index
- 9.2.27. pg_inherits
- 9.2.28. pg_init_privs
- 9.2.29. pg_language
- 9.2.30. pg_largeobject
- 9.2.31. pg_largeobject_metadata
- 9.2.32. pg_namespace
- 9.2.33. pg_opclass
- 9.2.34. pg_operator
- 9.2.35. pg_opfamily
- 9.2.36. pg_parameter_acl
- 9.2.37. pg_partitioned_table
- 9.2.38. pg_policy
- 9.2.39. pg_proc
- 9.2.40. pg_publication
- 9.2.41. pg_publication_namespace
- 9.2.42. pg_publication_rel
- 9.2.43. pg_range
- 9.2.44. pg_replication_origin
- 9.2.45. pg_rewrite
- 9.2.46. pg_seclabel
- 9.2.47. pg_sequence
- 9.2.48. pg_shdepend
- 9.2.49. pg_shdescription
- 9.2.50. pg_shseclabel
- 9.2.51. pg_statistic
- 9.2.52. pg_statistic_ext
- 9.2.53. pg_statistic_ext_data
- 9.2.54. pg_subscription
- 9.2.55. pg_subscription_rel
- 9.2.56. pg_tablespace
- 9.2.57. pg_transform
- 9.2.58. pg_trigger
- 9.2.59. pg_ts_config
- 9.2.60. pg_ts_config_map
- 9.2.61. pg_ts_dict
- 9.2.62. pg_ts_parser
- 9.2.63. pg_ts_template
- 9.2.64. pg_type
- 9.2.65. pg_user_mapping
- 9.3. System Views
- 9.3.1. Overview
- 9.3.2. pg_available_extensions
- 9.3.3. pg_available_extension_versions
- 9.3.4. pg_backend_memory_contexts
- 9.3.5. pg_config
- 9.3.6. pg_cursors
- 9.3.7. pg_file_settings
- 9.3.8. pg_group
- 9.3.9. pg_hba_file_rules
- 9.3.10. pg_ident_file_mappings
- 9.3.11. pg_indexes
- 9.3.12. pg_locks
- 9.3.13. pg_matviews
- 9.3.14. pg_policies
- 9.3.15. pg_prepared_statements
- 9.3.16. pg_prepared_xacts
- 9.3.17. pg_publication_tables
- 9.3.18. pg_replication_origin_status
- 9.3.19. pg_replication_slots
- 9.3.20. pg_roles
- 9.3.21. pg_rules
- 9.3.22. pg_seclabels
- 9.3.23. pg_sequences
- 9.3.24. pg_settings
- 9.3.25. pg_shadow
- 9.3.26. pg_shmem_allocations
- 9.3.27. pg_stats
- 9.3.28. pg_stats_ext
- 9.3.29. pg_stats_ext_exprs
- 9.3.30. pg_tables
- 9.3.31. pg_timezone_abbrevs
- 9.3.32. pg_timezone_names
- 9.3.33. pg_user
- 9.3.34. pg_user_mappings
- 9.3.35. pg_views
- 9.4. Frontend/Backend Protocol
- 9.4.1. Overview
- 9.4.2. Message Flow
- 9.4.3. SASL Authentication
- 9.4.4. Streaming Replication Protocol
- 9.4.5. Logical Streaming Replication Protocol
- 9.4.6. Message Data Types
- 9.4.7. Message Formats
- 9.4.8. Error and Notice Message Fields
- 9.4.9. Logical Replication Message Formats
- 9.4.10. Summary of Changes since Protocol 2.0
- 9.5. PostgreSQL Coding Conventions
- 9.6. Native Language Support
- 9.7. Writing a Procedural Language Handler
- 9.8. Writing a Foreign Data Wrapper
- 9.9. Writing a Table Sampling Method
- 9.10. Writing a Custom Scan Provider
- 9.11. Genetic Query Optimizer
- 9.12. Table Access Method Interface Definition
- 9.13. Index Access Method Interface Definition
- 9.14. Generic WAL Records
- 9.15. Custom WAL Resource Managers
- 9.16. B-Tree Indexes
- 9.17. GiST Indexes
- 9.18. SP-GiST Indexes
- 9.19. GIN Indexes
- 9.20. BRIN Indexes
- 9.21. Hash Indexes
- 9.22. Database Physical Storage
- 9.23. System Catalog Declarations and Initial Contents
- 9.24. How the Planner Uses Statistics
- 9.25. Backup Manifest Format
- 10. Appendixes
- 10.1. Date/Time Input Interpretation
- 10.2. Handling of Invalid or Ambiguous Timestamps
- 10.3. Date/Time Key Words
- 10.4. Date/Time Configuration Files
- 10.5. POSIX Time Zone Specifications
- 10.6. History of Units
- 10.7. Julian Dates
- 10.8. Supported Features
- 10.9. Unsupported Features
- 10.10. XML Limits and Conformance to SQL/XML
- 10.11. Release 15.1
- 10.12. Release 15
- 10.13. Prior Releases
- 10.14. adminpack
- 10.15. amcheck
- 10.16. auth_delay
- 10.17. auto_explain
- 10.18. basebackup_to_shell
- 10.19. basic_archive
- 10.20. bloom
- 10.21. btree_gin
- 10.22. btree_gist
- 10.23. citext
- 10.24. cube
- 10.25. dblink
- 10.26. Description
- 10.27. Arguments
- 10.28. Return Value
- 10.29. Notes
- 10.30. Examples
- 10.31. Description
- 10.32. Description
- 10.33. Arguments
- 10.34. Return Value
- 10.35. Examples
- 10.36. Description
- 10.37. Arguments
- 10.38. Return Value
- 10.39. Notes
- 10.40. Examples
- 10.41. Description
- 10.42. Arguments
- 10.43. Return Value
- 10.44. Examples
- 10.45. Description
- 10.46. Arguments
- 10.47. Return Value
- 10.48. Notes
- 10.49. Examples
- 10.50. Description
- 10.51. Arguments
- 10.52. Return Value
- 10.53. Notes
- 10.54. Examples
- 10.55. Description
- 10.56. Arguments
- 10.57. Return Value
- 10.58. Notes
- 10.59. Examples
- 10.60. Description
- 10.61. Return Value
- 10.62. Examples
- 10.63. Description
- 10.64. Arguments
- 10.65. Return Value
- 10.66. Notes
- 10.67. Examples
- 10.68. Description
- 10.69. Arguments
- 10.70. Return Value
- 10.71. Examples
- 10.72. Description
- 10.73. Arguments
- 10.74. Return Value
- 10.75. Examples
- 10.76. Description
- 10.77. Arguments
- 10.78. Return Value
- 10.79. Examples
- 10.80. Description
- 10.81. Arguments
- 10.82. Return Value
- 10.83. Notes
- 10.84. Examples
- 10.85. Description
- 10.86. Arguments
- 10.87. Return Value
- 10.88. Examples
- 10.89. Description
- 10.90. Arguments
- 10.91. Return Value
- 10.92. Examples
- 10.93. Description
- 10.94. Arguments
- 10.95. Return Value
- 10.96. Notes
- 10.97. Examples
- 10.98. Description
- 10.99. Arguments
- 10.100. Return Value
- 10.101. Notes
- 10.102. Examples
- 10.103. Description
- 10.104. Arguments
- 10.105. Return Value
- 10.106. Notes
- 10.107. Examples
- 10.108. dict_int
- 10.109. dict_xsyn
- 10.110. earthdistance
- 10.111. file_fdw
- 10.112. fuzzystrmatch
- 10.113. hstore
- 10.114. intagg
- 10.115. intarray
- 10.116. isn
- 10.117. lo
- 10.118. ltree
- 10.119. old_snapshot
- 10.120. pageinspect
- 10.121. passwordcheck
- 10.122. pg_buffercache
- 10.123. pgcrypto
- 10.124. pg_freespacemap
- 10.125. pg_prewarm
- 10.126. pgrowlocks
- 10.127. pg_stat_statements
- 10.128. pgstattuple
- 10.129. pg_surgery
- 10.130. pg_trgm
- 10.131. pg_visibility
- 10.132. pg_walinspect
- 10.133. postgres_fdw
- 10.133.1. FDW Options of postgres_fdw
- 10.133.2. Functions
- 10.133.3. Connection Management
- 10.133.4. Transaction Management
- 10.133.5. Remote Query Optimization
- 10.133.6. Remote Query Execution Environment
- 10.133.7. Cross-Version Compatibility
- 10.133.8. Configuration Parameters
- 10.133.9. Examples
- 10.133.10. Author
- 10.134. seg
- 10.135. sepgsql
- 10.136. spi
- 10.137. sslinfo
- 10.138. tablefunc
- 10.139. tcn
- 10.140. test_decoding
- 10.141. tsm_system_rows
- 10.142. tsm_system_time
- 10.143. unaccent
- 10.144. uuid-ossp
- 10.145. xml2
- 10.146. Client Applications
- 10.147. Server Applications
- 10.148. Client Interfaces
- 10.149. Administration Tools
- 10.150. Procedural Languages
- 10.151. Extensions
- 10.152. Getting the Source via Git
- 10.153. DocBook
- 10.154. Tool Sets
- 10.155. Building the Documentation
- 10.156. Documentation Authoring
- 10.157. Style Guide
- 10.158. When Color is Used
- 10.159. Configuring the Colors