# HG changeset patch
# User Oleksandr Gavenko <gavenkoa@gmail.com>
# Date 1546940714 -7200
# Node ID c6c55f6a45c8531ce590d0717fdfa9493d33165c
# Parent  4cd18bed8bac8627b856ee45d5c6b33b2ca1399b
List constraints.

diff -r 4cd18bed8bac -r c6c55f6a45c8 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.