Looking for a JavaEE Architect or Potential Tech Co-Founder?
Please don't hesitate to contact me.

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.