PostgreSQL Extensions
Explore how PostgreSQL extensions add powerful features to the database system, from supporting new programming languages and spatial data to enabling foreign data wrappers. Understand how to install and manage these extensions at runtime to extend PostgreSQL's capabilities tailored to development and administration needs.
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 ...