t18n · November 26, 2018 01:59
diff --git a/Show all constraints PostgresSQL.sql b/Show all constraints PostgresSQL.sql
 SELECT conrelid::regclass AS table_from
     , conname
     , pg_get_constraintdef(c.oid)
 FROM   pg_constraint c
 JOIN   pg_namespace n ON n.oid = c.connamespace
 WHERE  contype IN ('f', 'p ')
 AND    n.nspname = 'public' -- your schema here
 ORDER  BY conrelid::regclass::text, contype DESC;
	SELECT conrelid::regclass AS table_from
	, conname
	, pg_get_constraintdef(c.oid)
	FROM pg_constraint c
	JOIN pg_namespace n ON n.oid = c.connamespace
	WHERE contype IN ('f', 'p ')
	AND n.nspname = 'public' -- your schema here
	ORDER BY conrelid::regclass::text, contype DESC;