List constraints.
authorOleksandr Gavenko <gavenkoa@gmail.com>
Tue, 08 Jan 2019 11:45:14 +0200
changeset 2337 c6c55f6a45c8
parent 2336 4cd18bed8bac
child 2338 4837614fea35
List constraints.
postgres.rst
--- a/postgres.rst	Tue Jan 08 00:59:38 2019 +0200
+++ b/postgres.rst	Tue Jan 08 11:45:14 2019 +0200
@@ -212,6 +212,7 @@
 
   SELECT * FROM pg_constraint;
   SELECT * FROM pg_constraint WHERE conrelid = (SELECT oid FROM pg_class WHERE relname LIKE 'tblName');
+  select * from pg_constraint where conname like '%conName%';
 
 https://www.postgresql.org/docs/current/catalog-pg-constraint.html
   pg_constraint.