PostgreSQL, also known as Postgres, is a free and open-source relational database management system emphasizing extensibility and SQL compliance. It 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. PostgreSQL is designed to handle a range of workloads, from single machines to data warehouses or web services with many concurrent users.
PostgreSQL features transactions with atomicity, consistency, isolation, durability (ACID) properties, automatically updatable views, materialized views, triggers, foreign keys, and stored procedures. It supports a large part of the SQL standard and offers many modern features. PostgreSQL can be extended by the user in many ways, for example by adding new data types.
PostgreSQL is highly stable and has earned a strong reputation for its proven architecture, reliability, data integrity, robust feature set, extensibility, and the dedication of the open-source community behind the software to consistently deliver performant and innovative solutions. It has been ACID-compliant since 2001 and supports advanced data types. PostgreSQL is used as the primary data store or data warehouse for many web, mobile, geospatial, and analytics applications.
PostgreSQL runs on all major operating systems, including Linux, FreeBSD, OpenBSD, and Windows. It is highly extensible and can be used, modified, and distributed by anyone free of charge for any purpose, be it private, commercial, or academic. PostgreSQL is commonly abbreviated as Postgres.
