PostgreSQL


Topic | v3 | updated by jjones |
Description

PostgreSQL, also known as Postgres, is a free and open-source relational database management system (RDBMS) emphasizing extensibility and SQL compliance. It was originally named POSTGRES, referring to its origins as a successor to the Ingres database developed at the University of California, Berkeley. In 1996, the project was renamed to PostgreSQL to reflect its support for SQL. After a review in 2007, the development team decided to keep the name PostgreSQL and the alias Postgres. PostgreSQL features transactions with Atomicity, Consistency, Isolation, Durability (ACID) properties, automatically updatable views, materialized views, triggers, foreign keys, and stored procedures. It is designed to handle a range of workloads, from single machines to data warehouses or Web services with many concurrent users. It is the default database for macOS Server, and is also available for Linux, FreeBSD, OpenBSD, and Windows.


Relations

a subtopic of Computer science

Computer science is the study of computation and information. Computer science deals with theory of c...

a parent of PostgreSQL identity column

PostgreSQL version 10 introduced a new feature called GENERATED AS IDENTITY constraint that allows yo...

is SQL

SQL (S-Q-L, "sequel"; Structured Query Language) is a domain-specific language used in programming an...


Edit topic New topic

Resources

No beginner resources matching your criteria have been registered, yet.

official PostgreSQL Documentation

8.0 rating 5.0 level 8.0 clarity 3.0 background – 1 rating

Latest PostgreSQL Documentation

No advanced resources matching your criteria have been registered, yet.

is treated in Postgres scaling advice for 2021 - CYBERTEC | PostgreSQL

This article covers scaling advices for PostgreSQL and explains, why it may be a good idea to keep it...