Supported PostgreSQL Extensions

PostgreSQL is an open source, object-relational database built for extensibility, data integrity, and speed. Its concurrency support makes it fully ACID-compliant, and it supports dynamic loading and catalog-driven operations to let users customize its data types, functions, and more.

To expand the functionality of your PostgreSQL cluster, you can use extensions, which are bundled packages of SQL objects.

Install, Upgrade, or Disable Extensions

You can install supported extensions with psql’s CREATE EXTENSION command:

CREATE EXTENSION <extension-name>;

You can upgrade extensions to their latest version with psql’s ALTER EXTENSION command:

ALTER EXTENSION <extension-name> UPDATE;

You can disable extensions with psql’s DROP EXTENSION command:

DROP EXTENSION <extension-name>;

To see a list of extensions currently installed, use the following command:

\dx

Supported Extensions

DigitalOcean PostgreSQL Managed Databases supports the following extensions. This list is current as of the Validated date on this page.

You can also see a list of available extensions from the psql’s command line, use the following command:

SELECT * FROM pg_available_extensions;

You can request support for an extension on ideas.digitalocean.com by either voting for an existing request or adding a new idea for Managed Databases.