Skip to content

Instantly share code, notes, and snippets.

@dickyaryag6

dickyaryag6/do-update-string.sql

Created September 5, 2021 06:18
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save dickyaryag6/1d7fb1121b7f5137810fab488e04469b to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save dickyaryag6/1d7fb1121b7f5137810fab488e04469b to your computer and use it in GitHub Desktop.
Download ZIP
Raw
do-update-string.sql
INSERT INTO person
(name, country, job, age)
values ('Peter', 'Egypt', 'Engineering Manager', 32)
ON CONFLICT (name)
DO UPDATE SET job = EXCLUDED.job || ',' || person.job;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment