The most important features of PostgreSQL are as follows :
Download : PostgreSQL is open-source software and free to download. We can easily download it from the official website of PostgreSQL.
Area of Compatibility
* PostgreSQL is compatible with several operating systems such as Microsoft Windows, Linux, MacOS X, UNIX (AIX, BSD, HP-UX, SGI IRIX, Solaris, and Tru64), etc.
* It is compatible with various programming languages such as C/C++, Java, Python, Perl, Ruby, Tcl, and ODBC (Open Database Connectivity).
PostgreSQL is compatible with multiple data types such as
* Structured data types, i.e., Array, Date and Time, UUID (Universally Unique Identifier), Array, Range, etc.
* Primitive data types, i.e., String, Integer, Boolean, Numeric, etc.
* Customizations data types, i.e., Custom Types, Composite, etc.
* Geometry data types, i.e., Polygon, Circle, Line, Point, etc.
* Document data types i.e. XML, JSON/JSONB, Key-value, etc.
Extensibility
* PostgreSQL is highly extensible as it supports procedural languages such as Perl, PL/PGSQL, Python, etc.
* It is compatible with foreign data wrappers, which connect to further databases with a standard SQL interface.
* It supports JSON/SQL path expressions, stored procedures, and functions.
* It supports a customizable storage interface for a table.
Secure and Highly Reliable
PostgreSQL is safe and secure because of the following security aspects :
* PostgreSQL provides a robust access control system and several authentications such as Lightweight Directory Access Protocol (LDAP), Generic Security Service Application Program Interface (GSSAPI), SCRAM-SHA-256, Security Support Provider Interface (SSPI), Certificate, etc.
* It also supports column and row-level security.
* It is highly reliable as it provides disaster recovery such as active standbys and PITR (Point in time recovery).
* It supports WAL (Write-ahead Logging)
* It supports different types of Replication like Synchronous, Asynchronous, and Logical.
* It supports Internationalization, which includes ICU collations, accent-insensitive and case-sensitive collations, and full-text searches.
* It is compatible with ANSI-SQL2008.
* It can improve the functionality of Server-Side programming.
