Create YSQL extensions
This page documents the preview (v2.21) version. Preview includes features under active development and is for development and testing only. For production, use the stable (v2024.1) version.
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.
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.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.