Global InformationPostgreSQL information
 The World's Most Advanced Open Source Relational Database[1] | |
| Developer(s) | PostgreSQL Global Development Group[2] |
|---|---|
| Initial release | 8 July 1996[3] |
| Stable release | 16.2[4] 
/ 8 February 2024 |
| Repository |
|
| Written in | C |
| Type | RDBMS |
| License | PostgreSQL License (free and open-source, permissive)[5][6][7] |
| Website | www |
| Publisher | PostgreSQL Global Development Group Regents of the University of California |
|---|---|
| Debian FSG compatible | Yes[8][9] |
| FSF approved | Yes[10] |
| OSI approved | Yes[7] |
| GPL compatible | Yes |
| Copyleft | No |
| Linking from code with a different licence | Yes |
| Website | postgresql |
PostgreSQL (/ˈpoʊstɡrɛs ˌkjuː ˈɛl/, POHST-gres kyoo el),[11][12] 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.[13] It is supported on all major operating systems, including Linux, FreeBSD, OpenBSD, macOS, and Windows, and handles a range of workloads from single machines to data warehouses 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[14] or temporal[15] database or features which emulate other database products.[16][17][18][19] Also available from third parties are a wide variety of user and machine interface features, such as graphical user interfaces[20][21][22] or load balancing and high availability toolsets.[23] 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.[24]
PostgreSQL was originally named POSTGRES, referring to its origins as a successor to the Ingres database developed at the University of California, Berkeley.[25][26] In 1996, the project 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.[27]
- ^ "PostgreSQL". Retrieved September 21, 2019.
PostgreSQL: The World's Most Advanced Open Source Relational Database
- ^ Cite error: The named reference
contributorswas invoked but never defined (see the help page). - ^ Cite error: The named reference
birthdaywas invoked but never defined (see the help page). - ^ "PostgreSQL 16.2, 15.6, 14.11, 13.14, and 12.18 Released!". February 8, 2024.
- ^ a b Cite error: The named reference
about/licencewas invoked but never defined (see the help page). - ^ Cite error: The named reference
approved by OSIwas invoked but never defined (see the help page). - ^ a b Cite error: The named reference
OSIwas invoked but never defined (see the help page). - ^ "Debian -- Details of package postgresql in sid". packages.debian.org. Retrieved January 25, 2021.
- ^ "Licensing:Main". FedoraProject.
- ^ "PostgreSQL". fsf.org.
- ^ "FAQ: What is PostgreSQL? How is it pronounced? What is Postgres?". PostgreSQL Wiki. PostgreSQL community. Retrieved October 2, 2021.
- ^ Cite error: The named reference
Audio samplewas invoked but never defined (see the help page). - ^ Cite error: The named reference
intro-whatiswas invoked but never defined (see the help page). - ^
"PostGIS". postgis.net. December 18, 2023. Retrieved December 18, 2023.
PostGIS extends the capabilities of the PostgreSQL relational database by adding support for storing, indexing, and querying geospatial data.
- ^
"Temporal Extensions". PostgreSQL Wiki. December 18, 2023. Retrieved December 18, 2023.
Postgres can be extended to become a Temporal Database. Such databases track the history of database content over time, automatically retaining said history and allowing it to be altered and queried.
- ^
"Orafce - Oracle's compatibility functions and packages". GitHub.com. December 17, 2023. Retrieved December 18, 2023.
Functions and operators that emulate a subset of functions and packages from the Oracle RDBMS.
- ^
"pg_dbms_job". GitHub.com. November 8, 2023. Retrieved December 18, 2023.
PostgreSQL extension to schedules and manages jobs in a job queue similar to Oracle DBMS_JOB package.
- ^
"WiltonDB". WiltonDB. 2023. Retrieved December 18, 2023.
WiltonDB [is] packaged for Windows. It strives to be usable as a drop-in replacement to Microsoft SQL Server.
- ^
"Babelfish for PostgreSQL". babelfishpg.org. Retrieved December 18, 2023.
Babelfish for PostgreSQL ... provides the capability for PostgreSQL to understand queries from applications written for Microsoft SQL Server.
- ^
"PostgreSQL Clients". wiki.postgresql.org. October 18, 2023. Retrieved December 18, 2023.
This page is a partial list of interactive SQL clients (GUI or otherwise) ... that you can type SQL in to and get results from them.
- ^
"Design Tools". wiki.postgresql.org. October 23, 2023. Retrieved December 18, 2023.
Tools to help with designing a schema, via creating Entity-Relationship diagrams and similar. Most are GUI.
- ^
"Community Guide to PostgreSQL GUI Tools". wiki.postgresql.org. December 1, 2023. Retrieved December 18, 2023.
This page is a list of miscellaneous utilities that work with Postgres (ex: data loaders, comparators etc.).
- ^
"Replication, Clustering, and Connection Pooling". wiki.postgresql.org. July 13, 2020. Retrieved December 18, 2023.
There are many approaches available to scale PostgreSQL beyond running on a single server. ... There is no one-size fits all...
- ^ This is recognized by the liberal permission to use the PostgreSQL name, as approved (for fair use, when not confusing people about a legal relationship with the actual PostgreSQL project) when used in support of PostgreSQL, subject to the PostgreSQL Trademark Policy:
"Trademark Policy". PostgreSQL.org. December 8, 2020. Retrieved December 17, 2023.
We will try to work with you to permit uses [of the PostgreSQL name] that support the PostgreSQL project and our Community.
- ^ Cite error: The named reference
designwas invoked but never defined (see the help page). - ^ Cite error: The named reference
about/historywas invoked but never defined (see the help page). - ^ Cite error: The named reference
Project namewas invoked but never defined (see the help page).