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;

Not all extensions listed in pg_available_extensions are installable. To access superuser-only extensions, refer to the superuser-only extensions list. If required, assign superuser privileges to enable their use.

Request support for a new extension by voting for an existing request or submitting a new idea.