Question : I recently had to copy over a databases structure from one database to another with the command pg_dump […]
Tag: hstore
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 […]
Use case for hstore
Question : This is the first time (I think) I have the chance to use the hstore data type, but […]
Create extension hstore
Question : I want to use hstore in my postgresql server running on CentOS 7 but hstore.control is not in […]
- 1
- 2