Computing Atlas

How Computing Was Built
Sign In
Text size
100%
Theme

Switch Atlas

System

PostgreSQL

Database Management System

PostgreSQL, also known as Postgres, is a free and open-source relational database management system (RDBMS) emphasizing extensibility and SQL compliance. It supports ACID-compliant transactions, views, triggers, and stored procedures, and runs on all major operating systems, including Windows, Linux, macOS, FreeBSD, and OpenBSD. It scales effectively from single machines to large data warehouses and concurrent web services.

Facts
Year
1996 1
Significance
An open-source object-relational database known for standards compliance and extensibility, the base for many derivative systems. 1
Status
Status
Active / In Use 1
Classification
License
PostgreSQL License 2
FAQs

Why is PostgreSQL also called Postgres?

Postgres is the original project name, kept as an alias after the 1996 rename to PostgreSQL.

The project was originally named POSTGRES, because it began at the University of California, Berkeley as a successor to the Ingres database. In 1996 it was renamed 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, so both names are in official use.
Connections

In Field

Databases, Fields
Source Wikipedia: PostgreSQL

Invented By

Tom Lane (computer scientist), Pioneers
Source Wikidata: PostgreSQL
Additional Source Tom Lane (computer scientist) (Wikipedia)Infobox: known_for

Licensed Under

PostgreSQL License, Concepts
Sources
1. Wikipedia: PostgreSQL
Wikimedia Foundation
  • Lead section
    PostgreSQL ( POHST-gres-kew-EL), also known as Postgres, is a free and open-source relational database management system (RDBMS) emphasizing extensibility and SQL compliance.
  • Article text
    The project continues to make releases available under its free and open-source software PostgreSQL License.
  • In Group: Relational Database Management System, lead states PostgreSQL is a free and open-source relational database management system (RDBMS)
View the Source
2. Wikidata: PostgreSQL
Wikidata Q192490, resolved via en.wikipedia pageprops (wave rule R-L)View the Source
Tom Lane (computer scientist) (Wikipedia)
Invented By: Tom Lane (computer scientist), Infobox: known_for
Quote, Invented By: Tom Lane (computer scientist), Infobox: known_for
Independent JPEG Group PostgreSQL Portable Network Graphics (PNG)
View the Source
Comments (0)
No comments yet. Be the first to share a thought.
Reader Challenges (0)
No disputes yet. Spotted an error or a better source? Open the first one.