Errors

A failed request throws DataApiError with status, code (invalid_query, unknown_table, permission_denied, conflict, …), message, and detail, hint and sqlstate when the server sends them. Every code is listed on Error codes.

try {
  await db.from("orders").insert({ total: "1.00", vip: false, history: [] });
} catch (e) {
  if (e instanceof DataApiError && e.code === "permission_denied") {
    console.log(e.status, e.message, e.sqlstate);
  } else {
    throw e;
  }
}

Answers without the data API's error bodyCopy Anchor Link

A non-2xx answer without the data API's error body (a proxy's error page) gets its code from the status:

Its message holds the status and the first 200 characters of the body. A 2xx answer that isn't JSON is a DataApiError with code: "internal". The client never follows a redirect (every request is sent with redirect: "manual"): a 3xx answer is a DataApiError with code: "internal" (in a browser, with status 0). Network failures are rethrown unchanged.

UnsafeIntegerErrorCopy Anchor Link

An int8 outside JavaScript's safe range throws UnsafeIntegerError instead of returning a rounded number. See Big numbers.