PostgreSQL 11.5 Documentation

KlustronDB大约 2 分钟

PostgreSQL 11.5 Documentation

The PostgreSQL Global Development Group

Table of Contents

[2. A Brief History of PostgreSQL](history.md)

[3. Conventions](notation.md)

[4. Further Information](resources.md)

[5. Bug Reporting Guidelines](bug-reporting.md)

I. Tutorial : 1. Getting Started

[2. The SQL Language](tutorial-sql.md)

[3. Advanced Features](tutorial-advanced.md)

II. The SQL Language : 4. SQL Syntax

[5. Data Definition](ddl.md)

[6. Data Manipulation](dml.md)

[7. Queries](queries.md)

[8. Data Types](datatype.md)

[9. Functions and Operators](functions.md)

[10. Type Conversion](typeconv.md)

[11. Indexes](indexes.md)

[12. Full Text Search](textsearch.md)

[13. Concurrency Control](mvcc.md)

[14. Performance Tips](performance-tips.md)

[15. Parallel Query](parallel-query.md)

III. Server Administration : 16. Installation from Source Code

[17. Installation from Source Code on Windows](install-windows.md)

[18. Server Setup and Operation](runtime.md)

[19. Server Configuration](runtime-config.md)

[20. Client Authentication](client-authentication.md)

[21. Database Roles](user-manag.md)

[22. Managing Databases](managing-databases.md)

[23. Localization](charset.md)

[24. Routine Database Maintenance Tasks](maintenance.md)

[25. Backup and Restore](backup.md)

[26. High Availability, Load Balancing, and Replication](high-availability.md)

[27. Recovery Configuration](recovery-config.md)

[28. Monitoring Database Activity](monitoring.md)

[29. Monitoring Disk Usage](diskusage.md)

[30. Reliability and the Write-Ahead Log](wal.md)

[31. Logical Replication](logical-replication.md)

[32. Just-in-Time Compilation (JIT)](jit.md)

[33. Regression Tests](regress.md)

IV. Client Interfaces : 34. libpq - C Library

[35. Large Objects](largeobjects.md)

[36. ECPG - Embedded SQL in C](ecpg.md)

[37. The Information Schema](information-schema.md)

V. Server Programming : 38. Extending SQL

[39. Triggers](triggers.md)

[40. Event Triggers](event-triggers.md)

[41. The Rule System](rules.md)

[42. Procedural Languages](xplang.md)

[43. PL/pgSQL - SQL Procedural Language](plpgsql.md)

[44. PL/Tcl - Tcl Procedural Language](pltcl.md)

[45. PL/Perl - Perl Procedural Language](plperl.md)

[46. PL/Python - Python Procedural Language](plpython.md)

[47. Server Programming Interface](spi.md)

[48. Background Worker Processes](bgworker.md)

[49. Logical Decoding](logicaldecoding.md)

[50. Replication Progress Tracking](replication-origins.md)

VI. Reference : I. SQL Commands

[II. PostgreSQL Client Applications](reference-client.md)

[III. PostgreSQL Server Applications](reference-server.md)

VII. Internals : 51. Overview of PostgreSQL Internals

[52. System Catalogs](catalogs.md)

[53. Frontend/Backend Protocol](protocol.md)

[54. PostgreSQL Coding Conventions](source.md)

[55. Native Language Support](nls.md)

[56. Writing A Procedural Language Handler](plhandler.md)

[57. Writing A Foreign Data Wrapper](fdwhandler.md)

[58. Writing A Table Sampling Method](tablesample-method.md)

[59. Writing A Custom Scan Provider](custom-scan.md)

[60. Genetic Query Optimizer](geqo.md)

[61. Index Access Method Interface Definition](indexam.md)

[62. Generic WAL Records](generic-wal.md)

[63. B-Tree Indexes](btree.md)

[64. GiST Indexes](gist.md)

[65. SP-GiST Indexes](spgist.md)

[66. GIN Indexes](gin.md)

[67. BRIN Indexes](brin.md)

[68. Database Physical Storage](storage.md)

[69. System Catalog Declarations and Initial Contents](bki.md)

[70. How the Planner Uses Statistics](planner-stats-details.md)

VIII. Appendixes : A. PostgreSQL Error Codes

[B. Date/Time Support](datetime-appendix.md)

[C. SQL Key Words](sql-keywords-appendix.md)

[D. SQL Conformance](features.md)

[E. Release Notes](release.md)

[F. Additional Supplied Modules](contrib.md)

[G. Additional Supplied Programs](contrib-prog.md)

[H. External Projects](external-projects.md)

[I. The Source Code Repository](sourcerepo.md)

[J. Documentation](docguide.md)

[K. Acronyms](acronyms.md)

Bibliography

Index