How do I add a Postgres extension to my database?

Issue

You want to install an extension in your Heroku Postgres database.

Resolution

Check the list of supported PostgreSQL extensions in Heroku Postgres in our DevCenter article "Extensions, PostGIS, and Full Text Search Dictionaries on Heroku Postgres".

You can install any of the supported extensions using CREATE EXTENSION.

It's not possible to install or use extensions that are not part of the supported extensions at the moment.

Ask on Stack Overflow

Engage with a community of passionate experts to get the answers you need

Ask on Stack Overflow

Heroku Support

Create a support ticket and our support experts will get back to you

Contact Heroku Support