How to install hstore in postgresql 9.1

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;
How to install hstore in postgresql 9.1 How to install hstore in postgresql 9.1 Reviewed by Edward Legaspi on Monday, August 13, 2012 Rating: 5

1 comment:

Jorge said...

Thanks! I was looking for this.

Powered by Blogger.