Create YSQL extensions

YugabyteDB includes a number of pre-bundled PostgreSQL extensions, tested to work with YSQL, that you can use to extend the functionality of your database.

{{< note title="Extensions must be pre-bundled" >}}

YugabyteDB Aeon only supports extensions that are pre-bundled in YugabyteDB. You cannot install new extensions in YugabyteDB Aeon. Refer to PostgreSQL extensions for the list of pre-bundled extensions.

{{< /note >}}

Loading extensions

Before using an extension, you must load it in the database using the CREATE EXTENSION command. For example:

CREATE EXTENSION fuzzystrmatch;

Required privileges

In YugabyteDB Aeon, extensions can only be loaded by users that are a member of the yb_extension role. All yb_superuser users, including the default database admin user, are members of yb_extension.

Use the GRANT statement to assign the role to users. For example, to grant the yb_extension role to user, use the following command:

yugabyte=# GRANT yb_extension TO user;

For more information on roles in YugabyteDB Aeon, refer to Database authorization in YugabyteDB Aeon clusters.

Learn more

• PostgreSQL extensions
• Database authorization in YugabyteDB Aeon clusters
• Manage Users and Roles in YSQL