Create YSQL extensions
YugabyteDB is bundled with a number of PostgreSQL extensions that are tested to work with YSQL.
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 Managed, 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 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.