Hacker News new | ask | show | jobs
by plugin-baby 1358 days ago
This sounds very neat. Do you have an example handy?
1 comments

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
      )