Question : According to docs , jsonb_each_text(jsonb) returns setof key text, value text but if you pg_typeof(value) on result it […]
Tag: json
How can I implement full-text search on a single value in a JSONB column?
Question : I have a table that stores a conversation between two people. The data will look something like this: […]
PostgreSQL – Flatten nested JSONB object array
Question : Im my database with Postgres 11, i have this JSON in my rows stored in a JSONB field, […]
Aggregated JSONB result in update query
Question : Introduction I created a toy example to extract the problem into a smaller part. Here is the schema […]
Does PostgreSQL support wildcard indexes on JSON?
Question : I have a multi-tenant service with a table like this: project_id | user_id | user_properties Each project belongs […]
PostgreSQL joining using JSONB
Question : I have this SQL: CREATE TABLE test(id SERIAL PRIMARY KEY, data JSONB); INSERT INTO test(data) VALUES (‘{“parent”:null,”children”:[2,3]}’), (‘{“parent”:1, […]
Update dynamic column names using keys from jsonb argument
Question : I’d like to write a generic procedure for Postgres 12 that updates a table’s columns depending on what […]
Does MariaDB support native JSON column data type?
Question : I’m not talking about dynamic columns, I’m asking about native column JSON data type. In simple words, can […]
merge json online postgresql 10
Question : I have the following tables: create table tags ( id bigserial primary key, file_id bigint, key varchar, num […]
Extract and combine multiple values from a jsonb column
Question : I am looking to extract multiple values from a jsonb column in Postgres, and am running into an […]