Chelabase
ManagementTables

Insert a row of all defaults

POST
/v1/databases/{id}/branches/{branch_id}/tables/{schema}/{table}/rows/default

Runs INSERT INTO <table> DEFAULT VALUES in one committed transaction (as the owner, or as role) and returns the inserted row as JSON. A table whose columns have no defaults fails with the constraint's error (constraint_violation).

Authorization

bearer
AuthorizationBearer <token>

In: header

Path Parameters

id*string

Database id

Formatuuid
branch_id*string

Branch id

Formatuuid
schema*string

Schema name

table*string

Table name

Request Body

application/json

TypeScript Definitions

Use the request body type in TypeScript.

database?string|null
role?string|null

Response Body

application/json

application/json

application/json

application/json

application/json

application/json

application/json

application/json

application/json

application/json

curl -X POST "https://example.com/v1/databases/497f6eca-6276-4993-bfeb-53cbbbba6f08/branches/497f6eca-6276-4993-bfeb-53cbbbba6f08/tables/string/string/rows/default" \  -H "Content-Type: application/json" \  -d '{}'
{  "row": {}}

One cell's full value POST

The whole value of one column of the row with the given primary key, as text (a grid's preview cuts long values). `key` names exactly the primary key's columns; strings bind as given, numbers and booleans as their JSON text, compared at the column's type without its length or precision (never cut or rounded to fit). A value over 64 MiB is 413. Read as a role the caller holds below Developer, the read runs as the role through the data API's connection (rest), so the Postgres database must have the data API on (409 `data_api_disabled`) and the worker's role check applies (403 `role_refused`); the answers are the same.

The database's types GET

Every type a column can take in one Postgres database of a branch (base, enum, domain, composite, range and multirange types, with their oids), for a type picker and for joining a table's columns by `type_oid`.