PostgreSQL

PostgreSQL

PostgreSQL (/ˈpoʊstɡrɛs ˌkjuː ˈɛ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. 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.

Caption
enPostgreSQL License
Comment
enPostgreSQL (/ˈpoʊstɡrɛs ˌkjuː ˈɛ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. 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.
Copyleft
enNo
DebianApproved
enYes
Depiction
Postgresql elephant.svg
Developer
enPostgreSQL Global Development Group
FsfApproved
enYes
Genre
Relational database
Genre
Relational database
GplCompatible
enYes
Has abstract
enPostgreSQL (/ˈpoʊstɡrɛs ˌkjuː ˈɛ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. 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 Windows, Linux, FreeBSD, and OpenBSD.
Hypernym
System
Is primary topic of
PostgreSQL
Label
enPostgreSQL
License
enPostgreSQL License
License
Free and open-source
Permissive software licence
Link from a Wikipage to an external page
www.apress.com/book/view/1590595475
web.archive.org/web/20090708113944/http:/www.apress.com/book/view/1590595475
archive.org/details/practicalpostgre00wors/page/636
www.apress.com/book/view/9781590594780
web.archive.org/web/20090409150911/http:/www.apress.com/book/view/9781590594780
www.2ndquadrant.com/books/
www.crunchydata.com/products/crunchy-bridge/
www.ibm.com/cloud/hyper-protect-dbaas
www.informit.com/store/product.aspx%3Fisbn=0672327562
www.postgresonline.com/store.php%3Fasin=1449326331
Link from a Wikipage to another Wikipage
.info
.org
32-bit computing
390
64-bit computing
ACID (computer science)
Active Directory
Adminer
Afilias
Aggregate function
Alibaba Cloud
Amazon Aurora
Amazon Redshift
Amazon Relational Database Service
Amazon Web Services
Apress
Arbitrary-precision arithmetic
ARM architecture
ARMv6
ARMv8
Artistic License
Aster Data Systems
Backcountry.com
BASF
Beta tester
Binary code
Bitmap index
Block Range Index
BSON
B-tree
Business
C (programming language)
C++
Category:Client-server database management systems
Category:Cross-platform software
Category:Free database management systems
Category:Free software programmed in C
Category:ORDBMS software for Linux
Category:PostgreSQL
Category:Relational database management software for Linux
Classless Inter-Domain Routing
Collation
Command-line program
Common table expressions
Comparison of relational database management systems
Concurrency control
Concurrent user
Console application
Constraint satisfaction
Database connection
Database scalability
Database schema
Database transaction
Database trigger
Data domain
Data manipulation language
Data modeling
Data type
Data warehouse
Dimension table
Disqus
DragonFly BSD
Dynamic array
ECPG
Embedded SQL
EnterpriseDB
Entity–relationship model
Expression index
Extensibility
Fact table
FlightAware
Foreign key
Fork (software development)
Free and open-source
Free and open-source software
FreeBSD
Front and back ends
Full text search
Full-text search
Generic Security Services Application Program Interface
Geni.com
Geographic data and information
Geographic information system
GiST
GlassFish
Go (programming language)
Graphical user interface
Grofers
Hash table
Heroku
Hierarchical and recursive queries in SQL
Hot standby
HP-UX
Hydrology
IBM AIX
IBM Cloud
IBM System z
Ident protocol
Ingres (database)
Inline expansion
Insert (SQL)
Instagram
Instruction set architecture
Internationalization and localization
International Space Station
Inverted index
IPv4
IPv6
IRIX
Isolation (database systems)
Itanium
Java (programming language)
JavaScript
Jelastic
Join (SQL)
JSON
Julia (programming language)
Kerberos (protocol)
K-nearest neighbors algorithm
LibreOffice
Lightweight Directory Access Protocol
Linux
List of databases using MVCC
LLVM
MAC address
MacOS
MacOS Server
Mandatory access control
Materialized view
MD5
Merge (SQL)
Met Office
Michael Stonebraker
Microsoft
Microsoft Azure
Microsoft Visual Studio
Microsoft Windows
MIPS architecture
MIT License
MongoDB
Multicloud
Multi-master replication
Multiversion concurrency control
MusicBrainz
Myspace
MySQL
MyYearbook
National Oceanic and Atmospheric Administration
National Weather Service
NetBSD
NEXRAD
Node.js
O'Reilly Media
Object identifier
Online analytical processing
OpenBSD
OpenIndiana
OpenOffice.org
OpenServer
OpenSolaris
OpenStreetMap
Operator overloading
OS
Packt Publishing
ParAccel
PA-RISC
Partial index
Partition (database)
Perl
Permissive software licence
pgSQL
PhpMyAdmin
Platform as a service
Platform as a Service
Pluggable authentication module
Point-in-time recovery
Polling (computer science)
PostGIS
Postgres-XL
PowerPC
Prepared query
Process (computing)
Programming language
PSM
Publish–subscribe pattern
Python (programming language)
Qt (software)
QUEL query languages
R (programming language)
RADIUS
Raspberry Pi
Reddit
Referential integrity
Regular expression
Relational database
Relational database management system
Replication (computing)
Role-oriented programming
Ruby (programming language)
Rust (programming language)
Salted Challenge Response Authentication Mechanism
Sams Publishing
Sandbox (computer security)
Savepoint
Security-Enhanced Linux
Security Support Provider Interface
Select (SQL)
Serializability
Serializable snapshot isolation
Shared library
Shared memory
SIGMOD
Skype
Slony-I
Snapshot isolation
Software as a service
Solaris (operating system)
Sony Online
SPARC
SQL
SQL
SQL:2016
Star schema
Stored procedure
Subroutine
Sun Fire
Sun xVM
Superuser
SymmetricDS
Synchronous replication
System under test
Tablespace
Tcl
The Guardian
Transaction processing
Transport Layer Security
TripAdvisor
Tru64 UNIX
Turing Award
Two-phase commit protocol
UltraSPARC T1
United Kingdom
Universally unique identifier
University of California, Berkeley
UnixWare
Update (SQL)
View (SQL)
Visual Basic
VMware
VMware vSphere
Weather radar
Web services
WhitePages.com
Wiki
Windows 2008
Windows Server 2019
Windows XP
Write-ahead logging
WxWidgets
X86
X86-64
XML
XML
XPath
Yandex
YugabyteDB
Linking
enYes
Logo
enPostgresql elephant.svg
LogoCaption
enThe World's Most Advanced Open Source Relational Database
Name
enPostgreSQL License
OperatingSystem
FreeBSD
Linux
MacOS
Microsoft Windows
OpenBSD
Operating system
FreeBSD
Linux
MacOS
Microsoft Windows
OpenBSD
OsiApproved
enYes
ProgrammingLanguage
C (programming language)
Programming language
C (programming language)
Publisher
enPostgreSQL Global Development Group
enRegents of the University of California
Released
8 July 1996
Release date
8 July 1996
SameAs
4690455-4
m.05ynw
Mx4rv4IEkZwpEbGdrcN5Y29ycA
PostgreSQL
PostgreSQL
PostgreSQL
PostgreSQL
PostgreSQL
PostgreSQL
PostgreSQL
PostgreSQL
PostgreSQL
PostgreSQL
PostgreSQL
PostgreSQL
PostgreSQL
PostgreSQL
PostgreSQL
PostgreSQL
PostgreSQL
PostgreSQL
PostgreSQL
PostgreSQL
PostgreSQL
PostgreSQL
PostgreSQL
PostgreSQL
PostgreSQL
PostgreSQL
PostgreSQL
PostgreSQL
PostgreSQL
PostgreSQL
PostgreSQL
PostgreSQL
PostgreSQL
PostgreSQL
PostgreSQL
PostgreSQL
PostgreSQL
PostgreSQL
PostgreSQL
PostgreSQL
PostgreSQL
Q192490
qRva
بوستجري إس كيو إل
پستگرس‌کیوال
পোস্টগ্রেএসকিউএল
போஸ்கிரெஸ்குயெல்
പോസ്റ്റ്ഗ്രേഎസ്ക്യുഎൽ
โพสต์เกรสคิวเอล
SeeAlso
Comparison of database tools
Subject
Category:Client-server database management systems
Category:Cross-platform software
Category:Free database management systems
Category:Free software programmed in C
Category:ORDBMS software for Linux
Category:PostgreSQL
Category:Relational database management software for Linux
Thumbnail
Postgresql elephant.svg?width=300
WasDerivedFrom
PostgreSQL?oldid=1122798483&ns=0
WikiPageLength
91177
Wikipage page ID
23824
Wikipage revision ID
1122798483
WikiPageUsesTemplate
Template:Anchor
Template:Citation needed
Template:Cite book
Template:Code
Template:Commons category
Template:Curlie
Template:GitHub
Template:Infobox software
Template:Infobox software license
Template:IPAc-en
Template:Kbd
Template:NA
Template:Official website
Template:Portal
Template:Refbegin
Template:Refend
Template:Reflist
Template:Respell
Template:See also
Template:Short description
Template:Snd
Template:Software in the Public Interest
Template:Start date and age
Template:Timeline PostgreSQL
Template:URL
Template:Use mdy dates
Template:Version
Template:Wikibooks
Template:Wikidata
Wordnet_type
synset-software-noun-1