Chelabase
ManagementTables

One cell's full value

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

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.

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.

column*string
database?string|null
key*
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

application/json

curl -X POST "https://example.com/v1/databases/497f6eca-6276-4993-bfeb-53cbbbba6f08/branches/497f6eca-6276-4993-bfeb-53cbbbba6f08/tables/string/string/cell" \  -H "Content-Type: application/json" \  -d '{    "column": "string",    "key": {}  }'
{  "bytes": 0,  "data_type": "string",  "value": "string"}

One table's or other relation's structure GET

Any relation the object list shows, with its `kind`. An ordinary table (`kind: table`) carries its columns, constraints, indexes, policies, privileges, options and comment, as the schema merge reads them; a table that inherits from another is read the same way. A view, materialized view, foreign table or partitioned table is read-only: its columns (in `attnum` order, with `format_type`'s text and `not_null`) and comment, every other list empty; a view's definition and a foreign table's options are never returned. A partition, an index, a sequence, a composite type, a relation in a schema the object list leaves out, or a missing one is 404.

Insert a row of all defaults POST

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`).