With SQLite, I've started using json_each on a JSON parameter for bulk inserts o...

plugin-baby · on Sept 29, 2022

This sounds very neat. Do you have an example handy?

fragile_frogs · on Sept 30, 2022

This is what I do in postgres:

  insert into your_table(id, created_at, uri, project_id)
  select id
       , created_at
       , endpoint as uri
       , project_id 
    from jsonb_to_recordset($1)
      as x(
          id uuid
        , created_at timestamptz
        , endpoint text
        , project_id uuid
      )