PostgreSQL is an advanced, enterprise-class open-source relational database that supports both SQL (relational) and JSON (non-relational) querying. It is a highly stable database management system backed by more than 20 years of community development. This thorough and collaborative approach has contributed to its high levels of resilience, integrity, and correctness. PostgreSQL is used as the primary data store or data warehouse for many web, mobile, geospatial, and analytics applications.

PostgreSQL possesses robust feature sets, including tablespaces, asynchronous replication, nested transactions, online/hot backups, and a refined query planner/optimizer. The PostgreSQL community has also developed extensions that extend the functionality of PostgreSQL database. PostgreSQL supports:

International character sets, multi-byte character encodings, and Unicode. 
Most SQL:2008 data types, including INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR, DATE, INTER-VAL, and TIMESTAMP.
Storage of large binary objects, including pictures, sounds, video, and maps.
Foreign keys, joins, views, triggers, and stored procedures.
Leading programming languages and protocols, including Python, Java, Perl, .Net, Go, Ruby, C/C++, Tcl, and ODBC.
It is locale-aware for sorting, case sensitivity, and formatting. The PostgreSQL database server is highly scalable both in the quantity of data it can manage and in the number of concurrent users it can accommodate.