PostgreSQL
Sign in to savePostgreSQL ( ), also known as Postgres, is a free and open-source relational database management system (RDBMS) emphasizing extensibility and SQL compliance. PostgreSQL features transactions with atomicity, consistency, isolation, durability (ACID) properties, automatically updatable views, materialized views, triggers, foreign keys, and stored procedures. It is supported on all major operating systems, including Windows, Linux, macOS, FreeBSD, and OpenBSD, and handles a range of workloads from single machines to data warehouses, data lakes, or web services with many concurrent users.
AI overview
PostgreSQL is a free and open-source database system that stores and organizes large amounts of data while emphasizing flexibility and strict adherence to standard database rules. It runs on virtually all major operating systems and can power anything from small personal projects to massive data warehouses and websites serving many users simultaneously.
AI-generated from the Wikipedia summary — may contain errors.
Key facts
- Software.name
- PostgreSQL
- Software.logo
- Postgresql elephant.svg
- Software.logo caption
- ''The World's Most Advanced Open Source Relational Database'' <!--
- Software.screenshot
- PostgreSQL 13.2 screenshot.png -->
- Software.developer
- PostgreSQL Global Development Group
- Software.latest release date
- <!--
- Software.latest preview version
- --> <!--
- Software.latest preview date
- -->
- Software.programming language
- C (and C++ for the LLVM dependency)
- Software.genre
- RDBMS
- Software.license
- PostgreSQL License (free and open-source, permissive)
- Software license.name
Article
35 sectionsContents
- History
- Ingres and University POSTGRES (1982–1994)
- Postgres95 (1994–1996)
- PostgreSQL (1996–present)
- Multiversion concurrency control (MVCC)
- Storage and replication
- Replication
- Indexes
- Schemas
- Data types
- User-defined objects
- Inheritance
- Other storage features
- Control and connectivity
- Foreign data wrappers
- Interfaces
- Procedural languages
- Triggers
- Asynchronous notifications
- Rules
- Other querying features
- Concurrency model
- Security
- Standards compliance
- Benchmarks and performance
- Platforms
- Database administration
- Notable users
- Service implementations
- Release history
- Ecosystem and Derivatives
- See also
- References
- Further reading
- External links
PostgreSQL ( ), also known as Postgres, is a free and open-source relational database management system (RDBMS) emphasizing extensibility and SQL compliance. PostgreSQL features transactions with atomicity, consistency, isolation, durability (ACID) properties, automatically updatable views, materialized views, triggers, foreign keys, and stored procedures. It is supported on all major operating systems, including Windows, Linux, macOS, FreeBSD, and OpenBSD, and handles a range of workloads from single machines to data warehouses, data lakes, or web services with many concurrent users.
The PostgreSQL Global Development Group focuses only on developing a database engine and closely related components. This core is, technically, what comprises PostgreSQL itself, but there is an extensive developer community and ecosystem that provides other important feature sets that might, traditionally, be provided by a proprietary software vendor. These include special-purpose database engine features, like those needed to support a geospatial or temporal database or features which emulate other database products. Also available from third parties are a wide variety of user and machine interface features, such as graphical user interfaces or load balancing and high availability toolsets. The large third-party PostgreSQL support network of people, companies, products, and projects, even though not part of The PostgreSQL Development Group, are essential to the PostgreSQL database engine's adoption and use and make up the PostgreSQL ecosystem writ large.