PostgreSQL extensions

PostgreSQL has a robust ecosystem of extensions that lets you expand the capability of your PostgreSQL instance. Extensions are plug-ins that give you extra functionality and features.

This section provides instructions to view and load the available PostgreSQL extensions.

Viewing available extensions

ObjectRocket supports most common PostgreSQL extensions.

To view a list of supported plug-ins, use the following steps:

  1. Connect to your PostgreSQL instance from the ObjectRocket service.
  2. Enter the following command to display a list of all extensions in the Postgres extensions directory.
SELECT * FROM pg_available_extensions

or

Enter this command to display a list of extensions allowed on the ObjectRocket service.

SHOW extwlist.extensions;

Note

The ObjectRocket service does not currently support all default Postgres extensions. Contact the Support team if you are interested in an extension that’s not currently available.

Loading an extension

To load an extension, follow these steps:

  1. Load a supported Postgres extension from the database where you want to add the functionality.

  2. Issue the CREATE EXTENSION command followed by the name of the extension.

    For example, enter the following code to create the uid-ossp extension:

CREATE EXTENSION "uuid-ossp";

Note

Extensions are only available in the databases in which you load them. You have to load the extension for every database where you want to use it.

Available extensions

For a list of available PostgreSQL extensions, view the ObjectRocket API documentation.