Basic

• PostgreSQL is an ORDBMS [Open-Source Object-Relational Database Management System].

• PostgreSQL indexes are used to enhance the retrieval of data from the databases.

• It is written in C programming language.

• It is cross-platform and runs on various operating systems such as Microsoft Windows, UNIX, FreeBSD, Mac OS X, Solaris, HP-UX, LINUX, and so on.

• It is the existing database for the macOS server.

• MVCC (Multi-Version Concurrency Control).

• It supports multiple Indexing such as Multicolumn, Partial, B-tree, and expressions.

• SQL sub-selects.

• Complex SQL queries.

• Streaming Replication

• It supports transactions, Nested Transactions through Savepoints.

• Just-in-time compilation of expressions

• Table partitioning.

• It supports procedural Languages such as Perl, PL/PGSQL, and Python, etc.

• JSON/SQL path expressions

• Stored procedures and functions.

• For tables, it supports a customizable storage interface.

• It is compatible with foreign data wrappers, which connect to further databases with a standard SQL interface.

• It supports Column and row-level security.

• It supports different types of Replication like Synchronous, Asynchronous, and Logical.

• Active standbys, PITR (Point in time recovery)

• It supports WAL (Write-ahead Logging)

• It supports Internationalization, which means that the international character sets include ICU collations, accent- insensitive and case-sensitive collations, and full-text searches.

• In PostgreSQL, a table can be set to inherit their characteristics from a "parent" table.

• It is compatible with ANSI-SQL2008.

• It will help us to improve the functionality of Server-Side programming.

• We can install several extensions to add additional functionality to PostgreSQL.