Create YSQL extensions
YugabyteDB is bundled with a number of PostgreSQL extensions that are tested to work with YSQL.
Before using an extension, you must load it in the database using the CREATE EXTENSION command. For example:
CREATE EXTENSION fuzzystrmatch;
In YugabyteDB Managed, extensions can only be loaded by users that are a member of the
yb_extension role. All
yb_superuser users, including the default admin user, are members of
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 Managed, refer to Database authorization in YugabyteDB Managed clusters.
Request support for a new extension
You cannot install new extensions in YugabyteDB Managed.
If you need a database extension that is not bundled with YugabyteDB added to a cluster, contact Yugabyte Support with the names of the cluster and extension, or reach out on Slack.