I have a jsonb column within my table that looks like this: [ { "id: "1231-213-331", "name" : "Object 1 Name" }, { "id: "4113-13-131-21", "name" : "Object 2 Name" } ] I am passing a json object into my…
How can I get filter the rows where the number of keys in a jsonb column object have a specific value? I've got a jsonb column that contains something like { "fri": "from_home", "mon": "from_home", "sat": "dont_work", "sun": "dont_work", "thu":…
I have a table with two columns and the following data. I'm stuck with this table's structure and have no possibility of revamping it since the company has grown significantly and a lot of features depend on that particular format.…
I have a JSONB column in a postgres database. The json object it holds is structured like this: { "kws": {}, "distinct": 0, "count": 0 } Some of the records have nonzero/non-null values, of course. A colleague has inserted quite…
I have a table with a JSONB row which holds data in this form: id data 1 {"key_1": "value1"} 2 {"another_key": "some_value"} Given another JSON structure like this {"key_1": ["value1", "value2"]}, what shall I use to get the first row…
I have a Postgres table that looks like this: CREATE TABLE products( id string, attributes jsonb, PRIMARY KEY(id) ); An example of attributes field could be like: { "endDate": [ "2024-02-20T21:00:00.000Z" ], "countries": [ "US","IT","ES" ], "type": [ "RETAIL" ],…
In our DB we have tables, that have 6-8 M records, this data is static and in order of performance optimization we decided to store some data from this tables in separate table, and for predefined filters use the values…
Using PostgreSQL 14 I have a table 'fruits' with a JSONB column named 'items' containing this sample data: [{"anz": 4, "typ": "Banana"}, {"anz": 5, "typ": "Apple"}, {"anz": 2, "typ": "Grapefruit"}] [{"anz": 1, "typ": "Banana"}, {"anz": 1, "typ": "Apple"}, {"anz": 3,…
I have a jsonb column in a table, and this colum (named services) contains an array of objects like this: [{"id": "1", "service_id": "4100002"}, {"id": "2", "service_id": "4100003"}, {"id": "3", "service_id": "410004"}] If this same table contains two more columns;…
I want to improve performance of my queries using GIN index on jsonb column for pattern matching For example, I have a table defined as: CREATE TABLE my_table ( uuid text, doc jsonb ); In every row of table doc…