Add HStore support to your Postgres database

Postgres doesn’t have HStore enabled by default (especially if you’re using Postgresapp on OSX ); There is a quick fix though.


# This is to enable hstore in your current database
$ psql YOUR_CURRENT_DATABASE -c 'create extension hstore;'

# And this is to enable it for your future databases
$ psql template1 -c 'create extension hstore;'

Simple !

Leave a comment

Your email address will not be published. Required fields are marked *