PostgreSQL extensions ====================== .. meta:: :description: Overview of the available 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: #. Connect to your PostgreSQL instance from the ObjectRocket service. #. Enter the following command to display a list of all extensions in the Postgres extensions directory. .. code-block:: bash SELECT * FROM pg_available_extensions or Enter this command to display a list of extensions allowed on the ObjectRocket service. .. code-block:: bash 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: #. Load a supported Postgres extension from the database where you want to add the functionality. #. Issue the CREATE EXTENSION command followed by the name of the extension. For example, enter the following code to create the uid-ossp extension: .. code-block:: bash 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 `_.