Question : I try to cast a JSON to a TYPE VOID_EVENT_CREATE, but I didn’t work because of the array. […]
Tag: json
Looping through JSON and insert data to Postgres DB
Question : Below is how i have my data at the moment. How would i achieve in postgres with Postgresql […]
PostgreSQL, finding elements by value in numeric JSON arrays
Question : I have a table defined as: create table dummy (jdata jsonb); I inserted the following two rows: insert […]
PostgreSQL JSONB: How to get an element from Array of Embedded Documents
Question : I am comparing MongoDB with PostgreSQL query abilities. I struggle a bit with finding simple equivalent for the […]
PostgreSql JSONB SELECT against multiple values
Question : I have a very simple JSON table which I populate with some sample data: CREATE TABLE jsonthings(d JSONB […]
postgres index for “?|” JSONB operator
Question : I have a jsonb row with objects/dictionairies : {“a”:1, “b”:2, “c”,3} I want to query rows that contain […]
Postgres jsonb complex query
Question : I have a table on PostgreSQL 10 that looks like: CREATE TABLE forms (id serial, form jsonb); INSERT […]
Using Python to insert JSON into PostgreSQL [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. This question does not appear to belong […]
Extract JSON array of numbers from JSON array of objects
Question : I have a table containing a json array of objects similar to this: id | record ____________________ name1 […]
PostgreSQL row as jsonb “array”, not “object”
Question : We are trying to emulate a proprietary DB, which has “global primary keys”, with PostgreSQL. That is what […]