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;'
Najnowsze komentarze