Chelabase
ManagementTables

The database's types

GET
/v1/databases/{id}/branches/{branch_id}/types

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.

Authorization

bearer
AuthorizationBearer <token>

In: header

Path Parameters

id*string

Database id

Formatuuid
branch_id*string

Branch id

Formatuuid

Query Parameters

database?string

The Postgres database; the branch's main database when absent.

Response Body

application/json

application/json

application/json

application/json

application/json

application/json

application/json

application/json

application/json

application/json

curl -X GET "https://example.com/v1/databases/497f6eca-6276-4993-bfeb-53cbbbba6f08/branches/497f6eca-6276-4993-bfeb-53cbbbba6f08/types"
{  "types": [    {      "array_oid": 0,      "base_type_oid": 0,      "category": "string",      "kind": "base",      "labels": [        "string"      ],      "name": "string",      "oid": 0,      "preferred": true,      "schema": "string",      "takes_modifiers": true    }  ]}

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

List a branch's roles GET

The branch's owner role first, then the others by name: roles made through the API and roles made in SQL, with their level, password state and the data API secret keys an owner-level role blocks. No passwords: read one with the connection details and `role`.