Skip to main content
Deno 2 is finally here 🎉️
Learn more
Go to Latest
variable tableUniqueQuery
import { tableUniqueQuery } from "https://deno.land/x/denogres@v0.7.0-alpha/src/queries/introspection.ts";

type

` SELECT tables.schemaname, class.relname AS table_name, pg_get_constraintdef(pg_constraint.oid) AS condef, contype, conname 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 contype = 'u' AND pg_get_constraintdef(pg_constraint.oid) LIKE '%,%' `