Skip to content
Programming

Add HStore support to your Postgres database

·1 min 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 !

Filed Under

Subscribe to the systems briefings

Practical diagnostics for products, teams, and institutions navigating AI-driven change.

About the Author

avatar
Zak El Fassi

Engineer-philosopher · Systems gardener · Digital consciousness architect

Share this post