Overview
PostgreSQL (often called Postgres) is an advanced, enterprise-class open-source relational database. It supports both SQL (relational) and JSON (non-relational) querying.
Key Features
- Extensibility: Custom types, functions, and operators.
- Reliability: Strong ACID compliance.
- Advanced Features: Window functions, Common Table Expressions (CTEs), Full-text search.