It was the default database for macOS Server and is also available for Linux, FreeBSD, OpenBSD, and Windows. It 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. After a review in 2007, the development team decided to keep the name PostgreSQL and the alias Postgres. In 1996, the project was renamed to PostgreSQL to reflect its support for SQL.
It was originally named POSTGRES, referring to its origins as a successor to the Ingres database developed at the University of California, Berkeley. PostgreSQL ( / ˈ p oʊ s t ɡ r ɛ s ˌ k juː ˈ ɛ l/, POHST-gres kyoo el), also known as Postgres, is a free and open-source relational database management system (RDBMS) emphasizing extensibility and SQL compliance. Linking from code with a different licence PostgreSQL License ( free and open-source, permissive)
