Skip to content

Instantly share code, notes, and snippets.

@LeoFalco
Last active June 15, 2021 18:35
Show Gist options
  • Save LeoFalco/2f7b817e19b3be2bf3f3cc7721cbc748 to your computer and use it in GitHub Desktop.
Save LeoFalco/2f7b817e19b3be2bf3f3cc7721cbc748 to your computer and use it in GitHub Desktop.
update table set target_column=jsonb_set(source_column::jsonb, '{targetProperty}', 'newValue'::jsonb, true)::text where false
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment