Product & software
PostgreSQL
An open-source relational database with SQL queries, transactions, extensible data types, and tools for protecting data integrity.
At a glance
- Data model
- Object-relational
- Query language
- SQL
Overview
PostgreSQL stores related records in tables and lets applications query them using SQL. Its object-relational design also accommodates structured documents and custom types. The project grew out of Berkeley's POSTGRES research and is maintained as open-source software.
Data integrity
Primary keys, foreign keys, uniqueness rules, and transactions let a database enforce relationships and group changes. These features matter when several parts of an application update shared records.
Beyond simple tables
PostgreSQL supports JSON, arrays, full-text search, custom functions, and extensions. These capabilities allow one database to serve varied workloads; choosing them still requires understanding the application's data and queries.
Sources and review
MOOR's explanatory text is supported by the following source links.
- About PostgreSQL — PostgreSQL Global Development Group
- PostgreSQL: supporting documentation — PostgreSQL Global Development Group