Skip to content
PUBLIC ESSAYprogramming

Add HStore support to your Postgres database

1 minute read

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 !

END OF PUBLIC ESSAY / NOTHING REMOVED

The ending remains here. The Workshop is another layer of time and intimacy, not a paywall cut through the argument.

See the work as it is becoming

Filed under

programming