Top "Hstore" questions

hstore is data type for storing sets of key/value pairs in Postgres, similar to hashes in Ruby and Perl, associative arrays in PHP or dictionaries in Python.

How to create a new database with the hstore extension already installed?

Recently I went into trouble trying to use hstore with Django. I installed hstore this way: $ sudo -u postgres psql …

sql postgresql postgresql-9.1 hstore
How to query values with wildcards in PostgreSQL hstore

I'm trying to query hstore for all the values of a certain key that match a search criteria. I can …

postgresql hstore
Why can only a superuser CREATE EXTENSION hstore, but not on Heroku?

When I attempt to enable hstore on my database: => CREATE EXTENSION IF NOT EXISTS hstore; ERROR: permission denied to …

postgresql heroku hstore
Passing column names dynamically for a record variable in PostgreSQL

Using PostgreSQL, column values from a table for 1st record are stored in a record variable. for ex: let the …

postgresql types plpgsql dynamic-sql hstore
How to use PostgreSQL hstore/json with JdbcTemplate

Is there a way to use PostgreSQL json/hstore with JdbcTemplate? esp query support. for eg: hstore: INSERT INTO hstore_…

java spring postgresql jdbctemplate hstore
Updating a single key/value pair in a Rails 4 and PostgreSQL json column?

I have a rather large json document that I have to store in a field for each Evaluation instance in …

ruby-on-rails json postgresql hstore
PG::UndefinedObject: ERROR: type "hstore" does not exist but it does

First of all, this may look like a duplicate of: postgres hstore exists and doesn't exist at same time but …

ruby-on-rails postgresql hstore
Best PostgreSQL datatype for storing key-value maps?

I'd like to store a simple map of key-value strings as a field in my PostgreSQL table. I intend to …

json postgresql sqldatatypes jsonb hstore
Can I store arrays in hstore with Rails

I want to save data like this: User.create(name:"Guy", properties:{url:["url1","url2","url3"], street_address:"asdf"}) Can …

ruby-on-rails arrays postgresql ruby-on-rails-4 hstore
How to setup django-hstore with an existing app managed by south?

I tried to use django-hstore using this nice tutorial. I added two classes to an existing app managed by South: …

python django psycopg2 hstore