engines

Run one SQL statement and get the rows; the SQL console's mode decides whether it may write

post/instances/{instance_id}/engines/postgres/query

Request

  • Base URL: https://app.lathe.live/api/v1
  • URL: https://app.lathe.live/api/v1/instances/{instance_id}/engines/postgres/query
  • Auth: none declared

Path parameters

instance_idstring required

Request body

sqlstring required

One SQL statement. The SQL console's mode decides what it may do: ro runs it on the box's read-only role, so a write is refused by Postgres itself; rw runs it as the owner.

databasestring nullable

Which database to run it on; the console's database when omitted.

Response

Successful Response

unknown required

Changes

No recorded changes to this operation across all 1 revision of this API.