Heroku Data Labs: Allow PostgreSQL extensions on any schema

Change effective on 12 May 2023

As part of our efforts in improving the Heroku Postgres extension experience, we released a new Data Labs feature. This feature enables users to install PostgreSQL extensions on schemas other than heroku_ext on existing Heroku Postgres add-ons.

You can enable this labs feature by running the command:

$ heroku data:labs:enable extensions-on-any-schema --addon DATABASE_URL
Enabling extensions-on-any-schema on postgresql-trapezoidal-57207...... done

This feature doesn’t modify any of your existing extensions and only applies to new extensions you install.

See the Data Labs article for more information and the Extensions, PostGIS, and Full Text Search Dictionaries on Heroku Postgres article for more details on Heroku Postgres extensions.