Skip to main content

Insert or Upsert Records

POST 
/v1/rdb/rest/:table

Insert single or multiple records, supports upsert operation

Request​

Path Parameters

    table stringrequired

    Table name

Query Parameters

    select string

    Return fields, supports * or specified field list

Header Parameters

    Prefer string

    Preference settings. return=representation returns the inserted data; resolution=merge-duplicates enables upsert and merges (updates) existing rows on primary key or unique constraint conflict (equivalent to ON CONFLICT ... DO UPDATE); resolution=ignore-duplicates enables upsert and skips conflicting rows without modifying existing data (equivalent to ON CONFLICT ... DO NOTHING).

Body

required
    oneOf

    object

Responses​

Insert successful

Response Headers
  • Content-Range string

    Number of affected rows

  • Preference-Applied string

    Applied preference settings

Schema
    oneOf
  • Array [

    • object

  • ]
Loading...