Question : I have a carts table with items hstore column. An example entry in this column is: carts.items row#1 […]
Tag: hstore
Adding hstore entries to an uninitialized (NULL) column
Question : I got bitten by this “feature” recently. If your hstore column is uninitialized and you start adding entries […]
hstore type does not exist with hstore installed postgresql
Question : I recently had to copy over a databases structure from one database to another with the command pg_dump […]
How to query hstore tag keys that match part of the filter string
Question : In PostgreSQL query, how can I filter the results by using any record that tags with a key […]
Dynamically convert hstore keys into columns for an unknown set of keys
Question : I have a database that stores a bunch of custom fields using hstore. In order to merge it […]
HStore vs. multiple tables with inheritance – do I have a good use case for HStore?
Question : My broader question here has to do with when it is appropriate to use HStore vs. multiple tables […]
Can I alter an HSTORE column to JSON datatype?
Question : Is there a way to modify an existing column of HSTORE datatype (that has data) to JSON datatype […]
How to filter hstore where values are not null in a trigger?
Question : The easiest way to explain the question is in the usage of an audit trigger. However, on insert […]
PostgreSQL: hstore trgm search on fixed key
Question : I have a table of products with custom properties for each product. So I have props::hstore column in […]
PostgreSQL: pg_upgrade failing because hstore incompatible
Question : I’m trying to migrate from PostgreSQL 9.4.5_2 -> 9.5.3 I’m trying to use pg_upgrade (from 9.5.3 distribution) and […]
- 1
- 2