Subscribe to RSS

Question 1

I'm building the backend for a platform that works similarly to a game. It includes a simple character customization system with a few properties that aren't particularly relevant to the product (...

Question 2

We use Postgres jsonb_agg function in criteria query API like this: cb.function( JSONB_AGG_FUNCTION_NAME, JsonNode.class, someJoin.get(someField) ...

Question 3

Assume I have many rows with jsonb data like this in their respective columns: { ..., "participants": { "one_uuid": { "id": "another_uuid", &...

Question 4

I have a table with data on user applications. It contains several fields: employee_id text, date date, app_info jsonb. +-------------+------------+------------+ | employee_id | date | app_info ...

Question 5

Is there an operator that extracts xx from '{"xx":123}'::jsonb? In my data I always have only one key, so something like #>>'{$.*}' that meets this requirement, perhaps exists. PS: ...

Question 6

I'm new to python and just came to a problem: i've set up a simple program to fetch some data from PostgreSQL database. They say that asyncpg library automatically converts JSONB data to Python ...

Question 7

I'm an experienced programmer (mainly c# and mysql, then moved to javascript/JQuery and now more recently nextjs), but new to nextjs and postgres. I'm trying to insert an object into a JSONB column, ...

Question 8

I'm working on a React Native app with Supabase as my backend. My products table has a style_tags column in JSONB array format, for example: [ { "tag": "streetwear", "weight&...

Question 9

I have this query: SELECT organisation_id, count((j->>'invoiceId')) AS count, sum((j->>'advanceAmount')::numeric(20,4)) AS sum FROM runs LEFT JOIN jsonb_array_elements(...

Question 10

I'm using this package to CRUD in a Postgres database https://github.com/porsager/postgres This is my query - it works fine to remove a index 0 or n... on a JSON array inside a jsonb column: UPDATE ...

Question 11

I'm using this package to CRUD in a Postgres database https://github.com/porsager/postgres This is my query: POSGRES_SQL`UPDATE pedidos SET destinatario = jsonb_set( destinatario, '...

Question 12

I seem to be having issues with the @> operator: CREATE TEMP TABLE test_jsonb (id SERIAL, data jsonb); INSERT INTO test_jsonb (data) VALUES ('[{"role_id": "1", "user_name&...

Question 13

Consider the following table: CREATE TABLE organization_data(data JSONB); And it has the following data: INSERT INTO organization_data (data) VALUES ('[{"department_name": "sales",...

Question 14

WITH pets AS (SELECT 'Dog' AS mainpet, ' [ { "petSpecies": "Dog", "mainMeal": "Meat" }, { "petSpecies": "Cat", "...

Question 15

I've got a table with the filed string Data { get; set; } of type jsonb: modelBuilder.Entity<LayoutEntity>(b => { b.Property(p => p.Data).IsRequired().HasColumnName("data")....

Collectives™ on Stack Overflow

Postgres JSON or JSONB to store game's character customization data

How to use jsonb functions in hibernate 6?

SELECT jsonb data based on specific children values/properties

postgres jsonb array aggregate functions

Looking for the operator that extracts the key of one of JSONB objects

python+asyncpg+PostgreSQL returns jsonb column as a string instead of an object

Getting typescript error "No overload matches this call" on Postgres INSERT/UPDATE statement into JSONB column

How to extract JSONB array values from a Supabase Postgres table and insert them into another table in React Native?

How to write a query with aggregates of json_array_elements in jOOQ

Postgres UPDATE table SET jsonb typed column with javascript var not work for remove an array item

Postgres UPDATE table SET jsonb_set returning invalid input syntax for type json using javascript

Postgres @> operator confusion

Joining JSONB array objects to an attribute on the same object

Postgresql: jsonb_path_query filter based on value from a table column

npgsql call jsonb_path_exists on string mapped jsonb

Hot Network Questions