How to Install Hstore in Postgresql

Recently, we've use hstore data type in our database because of its key, value pair functionality and here's how I install hstore in my ubuntu 12.04:

1.) execute in terminal
>sudo apt-get update
>sudo apt-get install postgresql-contrib-9.1

2.) execute in the database/schema where you wanted to use hstore datatype:

>create extension hstore;

1 Comments

Post a Comment

Post a Comment

Previous Post Next Post
NERV Open Source
Building production Spring Boot systems?

Explore NERV — open-source Java libraries for audit trails, persistence, exception handling, and reliable event-driven architecture.