Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange
Make your voice heard. Take the 2019 Developer Survey now

All versions of PostgreSQL. Add an additional version-specific tag like postgresql-11 if that context is important.

PostgreSQL is a powerful, open source ACID complaint MVCC database system with a proven architecture that has earned a strong reputation for standards-compliance, reliability, data integrity, and extensiblity.

PostgreSQL runs on all major operating systems.

Functionality

PostgreSQL supports foreign keys, transactions, and window functions. As well as views and materialized views, triggers, CTEs (including recursive CTEs), scalar-functions, and table-value functions. Functions can be written in multiple languages including C, PL/pgSQL (a PostgreSQL variant of PL), Python, Perl, TCL, and numerous other languages including Java, Lua, R, sh, and v8 ECMAScript/JavaScript.

Types

PostgreSQL supports many types natively, including

Also supported are user-implemented types in C which have produced an ecosystem of extensions that add support for things big numbers, phone numbers and SI Units.

PostgreSQL also supports storage of binary large objects, (ie., pictures, sounds, or video). It has native programming interfaces for most compiled, and interpreted languages.

DOMAINs

PostgreSQL supports SQL DOMAINs over native types for when you want data validity attached to the type and not the containing table or function. This can be useful for things like storing email addresses

Indexes

PostgreSQL supports multicolumn, unique, full, and partial indexes and indexes on expressions and functions. These indexes can be created as btree, hash, bloom, BRIN (for large tables), GIST or GIN (inverted) indexes, and trigram for indexes on un-anchored search patterns.

Replication and High Availability

PostgreSQL supports both logical publish/subscribe replication, and WAL-shipping.

See also PostgreSQL Docs: High Availability, Load Balancing, and Replication

Extensions

PostgreSQL extensions provide additionally capabilities.

Spatial

The GIS system, provided by PostGIS, is the best in the industry providing a downloader for CENSUS data that provides geocoding. PostGIS is further expanded with PgRouting which provides Shortest-Path functionality to achieve a quick Google Maps routing ability.

See also

License

PostgreSQL's source code is available under a liberal open source license: the PostgreSQL License. This license gives you the freedom to use, modify and distribute PostgreSQL in any form you like, open or closed source. Any modifications, enhancements, or changes you make are yours to do with as you please.

history | excerpt history