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

type

` SELECT tables.schemaname, class.relname AS table_name, pg_get_constraintdef(pg_constraint.oid) AS condef, contype FROM pg_class class INNER JOIN pg_tables tables on class.relname = tables.tablename INNER JOIN pg_constraint ON class.oid = pg_constraint.conrelid WHERE tables.schemaname NOT IN ('pg_catalog', 'information_schema');`