hstore Archives

Postgres nested hstore select query

By adminPosted on January 25, 2023

Question : I have a carts table with items hstore column. An example entry in this column is: carts.items row#1 […]

By adminPosted on December 11, 2022

Question : I got bitten by this “feature” recently. If your hstore column is uninitialized and you start adding entries […]

By adminPosted on September 18, 2022

Question : I recently had to copy over a databases structure from one database to another with the command pg_dump […]

By adminPosted on June 21, 2022

Question : In PostgreSQL query, how can I filter the results by using any record that tags with a key […]

By adminPosted on May 8, 2022

Question : I have a database that stores a bunch of custom fields using hstore. In order to merge it […]

By adminPosted on March 31, 2022

Question : My broader question here has to do with when it is appropriate to use HStore vs. multiple tables […]

By adminPosted on March 17, 2022

Question : Is there a way to modify an existing column of HSTORE datatype (that has data) to JSON datatype […]

By adminPosted on February 15, 2022

Question : The easiest way to explain the question is in the usage of an audit trigger. However, on insert […]

By adminPosted on December 8, 2021

Question : I have a table of products with custom properties for each product. So I have props::hstore column in […]

By adminPosted on October 17, 2021

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 […]