| author | Oleksandr Gavenko <gavenkoa@gmail.com> |
| Tue, 08 Jan 2019 11:45:14 +0200 (2019-01-08) | |
| changeset 2337 | c6c55f6a45c8 |
| parent 2336 | 4cd18bed8bac |
| child 2338 | 4837614fea35 |
| postgres.rst | file | annotate | diff | comparison | revisions |
--- 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.