4 ms·
No dynamic SQL necessary. jsonb_populate_record(…) was made precisely for this kind of scenario. Combine with an INSERT…ON CONFLICT DO UPDATE statement and Bob
by ttfkam 4y ago
No dynamic SQL necessary.
jsonb_populate_record(…) was made precisely for this kind of scenario. Combine with an INSERT…ON CONFLICT DO UPDATE statement and Bob's your uncle.
https://www.postgresql.org/docs/current/functions-json.html https://www.postgresql.org/docs/current/functions-json.html