Skip to main content
Deno 2 is finally here 🎉️
Learn more
Latest
variable enumQuery
import { enumQuery } from "https://deno.land/x/denogres@v4.0.1/src/queries/introspection.ts";

type

` WITH enum_table as ( select n.nspname as enum_schema, t.typname as enum_name, string_agg(e.enumlabel, ', ' order by e.enumsortorder) as enum_value from pg_type t join pg_enum e on t.oid = e.enumtypid join pg_catalog.pg_namespace n ON n.oid = t.typnamespace group by enum_schema, enum_name ) select * from enum_table;`