PostgreSQL 9.3.1 Chinese Manual

PostgreSQL Global Development Group

Copyright © 1996-2013 PostgreSQL Global Development Group

This Chinese manual is organized by PostgreSQL China Users Association and translated by developers of Shandong Hangao represented by Yuan Yuan and Han Yueyue and other volunteers based on PostgreSQL 8.2.3 Chinese Document written by Mr. He Weiping. For details, see PostgreSQL 9.3.1 Chinese Manual 1.1 release notes. If you find problems in the Chinese manual, please send feedback to the Github source code repository or PostgreSQL Chinese Manual Translation group QQ group (309292849), or submit changes directly to the Github source code repository.

Version :1.2 Last updated on 2016-04-27

catalogue

introduction

What is PostgreSQL?
PostgreSQLBrief history
Format convention
More information
Bug reporting guide

I. Tutorials

1. Start at the beginning
2. SQLLanguage
3. Advanced features

II. SQL language

4. SQL syntax
5. Data definition
6. Data manipulation
7. inquire
8. Data type
9. Functions and operators
10. Type conversion
11. index
12. Full-text search
13. Concurrency control
14. Performance improvement tips

III. Server management

15. Source code installation
16. WindowsInstall with source code below
17. Server Settings and operations
18. Server configuration
19. User authentication
20. Database role
21. Management database
22. region
23. Daily database maintenance work
24. Backup and recovery
25. High availability and load balancing, replication
26. Restore configuration
27. Monitor database activity
28. Monitor disk usage
29. Reliability and prewrite logging
30. Regression test

IV. Client interface

31. libpq-C library
32. Large object
33. ECPG- Embedded in CSQL
34. Information pattern

V. Server-side programming

35. extendSQL
36. flip-flop
37. Event trigger
38. Rule system
39. Procedural language
40. PL/pgSQL - SQLProcedural language
41. PL/Tcl - Tcl procedural language
42. PL/Perl - The Perl procedural language
43. PL/Python - The Python procedural language
44. Server programming interface
45. Background work process

VI. Reference manual

I. SQL command
II. PostgreSQL client applications
III. PostgreSQL server applications

VII. interior

46. PostgreSQL internal Overview
47. System table
48. Front/back end protocol
49. PostgreSQL coding conventions
50. Native language support
51. Write a procedural language processor
52. Write an external data wrapper
53. Gene query optimizer
54. Index access method interface definition
55. GiST index
56. SP-GiST Index
57. GIN index
58. Database physical storage
59. BKIBack-end interface
60. How does the planner use statistics

VIII. appendix

A. PostgreSQLError code
B. Date/time support
C. SQLkeyword
D. SQL compatibility
E. Version description
F. Additional modules provided
G. Additional programs provided
H. External item
I. Source code library
J. document
K. An acronym

bibliography

		Next page
		introduction