Editorial and verification policy
How this site selects sources, tests SQL, labels versions, and maintains AI-assisted content
Accountability
PostgreSQL Field Guide is an independent community knowledge base. It is not affiliated with the PostgreSQL Global Development Group or the cloud vendors it covers. The site provides learning paths, engineering explanations, and verifiable examples; the official documentation for the target PostgreSQL version remains normative.
Source priority
- Official manuals, release notes, and versioning pages for supported PostgreSQL versions.
- Upstream repositories and release notes for extensions such as pgvector.
- Vendor documentation bound to a specific product, region, and engine version.
- Reproducible local tests and public technical standards.
Community articles can help discover questions, but never stand alone for version, API, security, or recovery claims.
Publication checks
- Verify SQL names, catalog views, and settings against the target-version manual instead of recalling interfaces.
- Run safely executable examples against an ephemeral PostgreSQL 18 instance where practical.
- State risks and prerequisites for writes, disruptive locks, recovery, privilege, and replication.
- Publish matching Chinese and English paths; neither language may be an empty placeholder or unreviewed machine translation.
- Date cloud-service claims and require readers to re-check region, SKU, and extension versions.
- Pass type checking, lint, production build, internal-link validation, and critical HTTP/SEO checks.
AI assistance disclosure
AI may assist research organization, translation drafts, example review, and consistency checks. It is not a factual source. Database-behavior claims must resolve to official material or reproducible tests; business semantics, risk acceptance, and production changes remain human decisions.
Dates and corrections
The “Last updated” marker represents the latest content-review date. Corrections should update both languages, cross-links, and machine-readable Markdown together, with a traceable note in the project's content audit record.
Current site-wide review baseline: 2026-08-02.
Last updated on