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 <https://docs.api.objectrocket.cloud/#available-extensions>`_.