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 !

Join the Conversation

1 Comment

  1. In case you didn’t realize, the word “Minimun” on your site is spelled incorrectly. I had similar issues on my website which hurt my credibility until someone pointed it out and I discovered some of the services like or which help with these type of issues.

Leave a comment

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