Questions tagged [postgresql]

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

PostgreSQL runs on all major operating systems and supports most of the major features of SQL:2016 including foreign keys, transactions, and window functions, views and materialized views, triggers, and CTEs (including recursive CTEs).
Functions and procedures can be written in multiple languages including C, PL/pgSQL, Python, Perl, TCL, and numerous other languages including Java, Lua, R, sh, and v8 ECMAScript/JavaScript.

Types

PostgreSQL supports most of the standard SQL types including:

• Boolean
• ENUMs (enumerated types)
• JSON and binary JSON
• XML
• Range types
• UUID
• ARRAY types
• Non-spatial geometric types (points, lines, line segments etc.)
• Network address types, including ip and mac types
• Binary large objects
• Domains (essentially data types with optional constraints)
• User-implemented types in C, which have produced an ecosystem of extensions

Indexes

PostgreSQL supports multicolumn, unique, full, partial and functional indexes, and combinations thereof. Index types include B-tree, Hash, GiST, SP-GiST, GIN and BRIN.

Replication and High Availability

PostgreSQL supports both logical replication, and WAL-shipping.

Extensions

A multitude of extensions provides additional capabilities. Notably, the spatial extension PostGIS is the best in the industry. See also postgis

License

PostgreSQL is released under the PostgreSQL License, a liberal Open Source license, similar to the BSD or MIT licenses.