PostgreSQL tips

Posted on 2018-03-07 in Trucs et astuces • Tagged with PostgreSQL, Database, SQL

Update fields in JSONB format

Use the jsonb_set(COLUMN_NAME, PATH_TO_CHANGE, VALUE) function. The value must be a valid value in JSON (ie use '500' for numbers, 'true' for …


Continue reading