The Postgres development platform. Supabase gives you a dedicated Postgres database to build your web, mobile, and AI applications.
TypeScript aialternativeauthdatabasedenoembeddingsexamplefirebasenextjsoauth2pgvectorpostgispostgrespostgresqlpostgrestrealtimesupabasevectorswebsockets
import { safeSql } from '../pg-format'
export const SCHEMAS_SQL = /* SQL */ safeSql`
-- Adapted from information_schema.schemata
select
n.oid as id,
n.nspname as name,
u.rolname as owner,
obj_description(n.oid, 'pg_namespace') AS comment
from
pg_namespace n,
pg_roles u
where
n.nspowner = u.oid
and (
pg_has_role(n.nspowner, 'USAGE')
or has_schema_privilege(n.oid, 'CREATE, USAGE')
)
and not pg_catalog.starts_with(n.nspname, 'pg_temp_')
and not pg_catalog.starts_with(n.nspname, 'pg_toast_temp_')
`