The hstore tag has no wiki summary.
5
votes
1answer
122 views
HStore vs. multiple tables with inheritance - do I have a good use case for HStore?
My broader question here has to do with when it is appropriate to use HStore vs. multiple tables vs. one table for storing document-like objects.
Now, for my localized example: I’m designing a ...
1
vote
0answers
32 views
PostgreSQL 9.3 slaves don't recognize hstore as a type
I am using the postgres built in replication with two slave nodes and a single master. On the master node (as well as the slaves) the hstore extension is installed. But whenever a query using hstore ...
1
vote
2answers
96 views
Extract all tags from hstore field
I need to extract (copy) all hstore tags by object id from a postgres 9.2+postgis 2.1 database into an external file for post-processing. Since the keys and values vary per record, and I don't know ...
0
votes
1answer
53 views
Attributes from an hstore-column as separate columns in a view?
Let's assume we have a table where it has two columns, one an ID and one an hstore column, which stores key/value pairs.
You could query that column as such:
SELECT name, attributes->'device' as ...
2
votes
1answer
205 views
Strange Postgres Hstore syntax with curly braces {key=value}
I'm using the following program https://sourceforge.net/projects/jailer/ to extract a subset of data from my database with correct associations following my foreign key constraints. The program ...
0
votes
1answer
106 views
Optimizing PostgreSQL hstore for lots of small updates
I have a situation where I will have one web session per row, but this session will generate dozens of updates to an hstore field in that row, one k/v at a time. At the end, I will have a completed ...
2
votes
1answer
706 views
Postgres nested hstore select query
I have a carts table with items hstore column. An example entry in this column is:
carts.items row#1 = {
"1614" => {:quantity=>"100", :price_cents=>1655},
...
