问题描述
该笔记将记录： 与 PostgreSQL 的语法、编程，以及相关问题的解决方案。
解决方案
该部分的主要内容均来自于官方文档，但是提取出在各章节中我们关注的内容，让我们形成对 PostgreSQL 的整体认识。
该部分内容主要来自官方文档的以下章节，偏向于 PostgreSQL 的 SQL 语法及使用：
I）Tutorial
— 01）Getting Started
— 02）The SQL Language
— 03）Advanced Features
II）The SQL Language
— 04）SQL Syntax
— 05）Data Definition
— 06）Data Manipulation
— 07）Queries
— 08）Data Types
— 09）Functions and Operators
— 10）Type Conversion
— 11）Indexes
— 12）Full Text Search
— 13）Concurrency Control
— 14）Performance Tips
— 15）Parallel Query
IV）Client Interfaces
— 34）libpq — C Library
— 35）Large Objects
— 36）ECPG — Embedded SQL in C
— 37）The Information Schema
V）Server Programming
— 38）Extending SQL
— 39）Triggers
— 40）Event Triggers
— 41）The Rule System
— 42）Procedural Languages
— 43）PL/pgSQL — SQL Procedural Language
— 44）PL/Tcl — Tcl Procedural Language
— 45）PL/Perl — Perl Procedural Language
— 46）PL/Python — Python Procedural Language
— 47）Server Programming Interface
— 48）Background Worker Processes
— 49）Logical Decoding
— 50）Replication Progress Tracking
VI）Reference
— I）SQL Commands
— II）PostgreSQL Client Applications
— III）PostgreSQL Server Applications
VII）Internals
— 51）Overview of PostgreSQL Internals
— 52）System Catalogs
— 53）Frontend/Backend Protocol
— 54）PostgreSQL Coding Conventions
— 55）Native Language Support
— 56）Writing a Procedural Language Handler
— 57）Writing a Foreign Data Wrapper
— 58）Writing a Table Sampling Method
— 59）Writing a Custom Scan Provider
— 60）Genetic Query Optimizer
— 61）Table Access Method Interface Definition
— 62）Index Access Method Interface Definition
— 63）Generic WAL Records
— 64）B-Tree Indexes
— 65）GiST Indexes
— 66）SP-GiST Indexes
— 67）GIN Indexes
— 68）BRIN Indexes
— 69）Hash Indexes
— 70）Database Physical Storage
— 71）System Catalog Declarations and Initial Contents
— 72）How the Planner Uses Statistics
— 73）Backup Manifest Format
VIII）Appendixes
— A）PostgreSQL Error Codes
— B）Date/Time Support
— C）SQL Key Words
— D）SQL Conformance
— E）Release Notes
— F）Additional Supplied Modules
— G）Additional Supplied Programs
— H）External Projects
— I）The Source Code Repository
— J）Documentation
— K）PostgreSQL Limits
— L）Acronyms
— M）Glossary
— N）Color Support
— O）Obsolete or Renamed Features
Bibliography
Index