Postgresql and hstore extension

Recently I needed to add hstore extension to postgresql… default in v. 9.3.5 its not installed… so on debian you should do:

$ sudo apt-cache search hstore
=> 
postgresql-contrib-9.1 - additional facilities for PostgreSQL
postgresql-8.4-hstore-new - PostgreSQL data type for storing sets of (key,value) pairs
postgresql-contrib-8.3 - additional facilities for PostgreSQL
postgresql-contrib-8.4 - additional facilities for PostgreSQL
postgresql-contrib-9.0 - additional facilities for PostgreSQL
postgresql-contrib-9.2 - additional facilities for PostgreSQL
postgresql-contrib-9.3 - additional facilities for PostgreSQL
postgresql-contrib-9.4 - additional facilities for PostgreSQL
postgresql-contrib-9.5 - additional facilities for PostgreSQL

choose proper facility for your pg version (you know this from… select version(); :D)

then of course

$ sudo apt-get install postgresql-contrib-9.3

and after installing it – log in to your db and put:

create extension hstore;
=> CREATE EXTENSION

and v’oila 😉

alter table posts add some_data_field hstore;
=> ALTER TABLE

You can add hstore to your template db, than forget it about adding extension to db

$ psql -d template1 -c 'create extension hstore;'