PostgreSQL tips
Posted on 2018-03-07 in Trucs et astuces • Tagged with PostgreSQL, Database, SQL
Sommaire
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