The Postgres development platform. Supabase gives you a dedicated Postgres database to build your web, mobile, and AI applications.
TypeScript aialternativeauthdatabasedenoembeddingsexamplefirebasenextjsoauth2pgvectorpostgispostgrespostgresqlpostgrestrealtimesupabasevectorswebsockets
import { z } from 'zod'
import { DEFAULT_SYSTEM_SCHEMAS } from './constants'
import { filterByList } from './helpers'
import { literal, safeSql, type SafeSqlFragment } from './pg-format'
import { TYPES_SQL } from './sql/types'
const pgTypeZod = z.object({
id: z.number(),
name: z.string(),
schema: z.string(),
format: z.string(),
enums: z.array(z.string()),
attributes: z.array(
z.object({
name: z.string(),
type_id: z.number(),
})
),
comment: z.string().nullable(),
})
const pgTypeArrayZod = z.array(pgTypeZod)
export type PGType = z.infer<typeof pgTypeZod>
function list({
includeArrayTypes = false,
includeSystemSchemas = false,
includedSchemas,
excludedSchemas,
limit,
offset,
}: {
includeArrayTypes?: boolean
includeSystemSchemas?: boolean
includedSchemas?: string[]
excludedSchemas?: string[]
limit?: number
offset?: number
} = {}): {
sql: SafeSqlFragment
zod: typeof pgTypeArrayZod
} {
let sql = TYPES_SQL
if (!includeArrayTypes) {
sql = safeSql`${sql} and not exists (
select from pg_type el
where el.oid = t.typelem
and el.typarray = t.oid
)`
}
const filter = filterByList(
includedSchemas,
excludedSchemas,
!includeSystemSchemas ? DEFAULT_SYSTEM_SCHEMAS : undefined
)
if (filter) {
sql = safeSql`${sql} and n.nspname ${filter}`
}
sql = safeSql`${sql} order by t.oid`
if (limit) {
sql = safeSql`${sql} limit ${literal(limit)}`
}
if (offset) {
sql = safeSql`${sql} offset ${literal(offset)}`
}
return {
sql,
zod: pgTypeArrayZod,
}
}
export { list }