...

/

PostgreSQL Extensions

PostgreSQL Extensions

Learn about the available PostgreSQL extensions with the help of an example.

A PostgreSQL extension is a set of SQL objects that we can add to PostgreSQL catalogs. Installing and enabling an extension can be done at runtime, making deploying extensions as simple as typing a single SQL command.

Listing PostgreSQL extensions

PostgreSQL extensions are available to cover different needs, such as the following list, which is not exhaustive:

Extensions for application developers

These extensions typically introduce an augmented feature set to PostgreSQL, making new specialized tricks available to your SQL queries.

Examples of such extensions include PostGIS, a spatial database extender for the PostgreSQL object-relational database that adds support for geographic objects allowing location queries to ...