插入数据或Upsert

POST 
/v1/rdb/rest/:table

插入单条或多条数据，支持upsert操作

Request

Path Parameters

table stringrequired

表名

Query Parameters

select string

返回字段，支持 * 或指定字段列表

Header Parameters

Prefer string

偏好设置。return=representation 返回插入后的数据；resolution=merge-duplicates 开启 upsert 并在主键或唯一约束冲突时合并（更新）已有数据（等同于 ON CONFLICT ... DO UPDATE）；resolution=ignore-duplicates 开启 upsert 并在冲突时跳过，不修改已有数据（等同于 ON CONFLICT ... DO NOTHING）

application/json

Body

required

oneOf
MOD1
object
MOD2
Array [
object
]

Responses

201

插入成功

Response Headers

• Content-Range string

  受影响的行数

• Preference-Applied string

  应用的偏好设置

application/json

Schema

Schema

oneOf

MOD1

Array [

object

]

MOD2

object

Example (from schema)

[
  null
]

400

请求错误

application/json

Schema

Schema

code string

错误码

details stringnullable

错误详情

hint stringnullable

错误提示

message string

错误信息

Example (from schema)

{
  "code": "PGRST106",
  "details": null,
  "hint": "Only the following schemas are exposed: public",
  "message": "Invalid schema: undefined"
}

Loading...