3 replies

Upsert Multiple using EXCLUDED

hey there - I want to upsert multiple values and overwrite certain fields in case of conflicts. using plain SQL it'd be something like this:

insert into
  "surveil" ("id", "last_seen", "name")
values
  ('1','2023-09-19 10:50:38.285+00', 'BanuniZ'),
  ('2','2023-09-19 10:50:38.285+00', 'Misha')
 on conflict (id) do update set "last_seen" = EXCLUDED."last_seen"

insert into
  "surveil" ("id", "last_seen", "name")
values
  ('1','2023-09-19 10:50:38.285+00', 'BanuniZ'),
  ('2','2023-09-19 10:50:38.285+00', 'Misha')
 on conflict (id) do update set "last_seen" = EXCLUDED."last_seen"

how could I achieve this with drizzle? I couldn't find anything in the docs...

Drizzle Team•3y ago•

3 replies

BaNuni

Upsert Multiple using EXCLUDED

hey there - I want to upsert multiple values and overwrite certain fields in case of conflicts. using plain SQL it'd be something like this:

insert into
  "surveil" ("id", "last_seen", "name")
values
  ('1','2023-09-19 10:50:38.285+00', 'BanuniZ'),
  ('2','2023-09-19 10:50:38.285+00', 'Misha')
 on conflict (id) do update set "last_seen" = EXCLUDED."last_seen"

insert into
  "surveil" ("id", "last_seen", "name")
values
  ('1','2023-09-19 10:50:38.285+00', 'BanuniZ'),
  ('2','2023-09-19 10:50:38.285+00', 'Misha')
 on conflict (id) do update set "last_seen" = EXCLUDED."last_seen"

how could I achieve this with drizzle? I couldn't find anything in the docs...

Upsert Multiple using EXCLUDED

Similar Threads

Upsert Multiple using EXCLUDED

Similar Threads

Similar Threads

Similar Threads