Published on

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 !