PostgreSQL 17 Documentation Skill

Overview

PostgreSQL is a powerful, open source object-relational database system that uses and extends the SQL language combined with many features that safely store and scale the most complicated data workloads. With more than 35 years of active development, PostgreSQL has earned a strong reputation for reliability, feature robustness, and performance.

Key Benefits

• ACID-compliant — full transactional integrity with MVCC
• Extensible — custom types, functions, operators, indexes, procedural languages
• Standards-compliant — SQL:2023 conformance with extensive extensions
• Scalable — parallel queries, partitioning, logical replication, connection pooling
• Rich type system — numeric, text, temporal, geometric, network, JSON, arrays, ranges, custom types
• Full text search — built-in tsvector/tsquery with dictionaries and ranking
• Procedural languages — PL/pgSQL, PL/Tcl, PL/Perl, PL/Python, and more
• High availability — streaming replication, log-shipping, hot standby, logical replication

File Index