equal
deleted
inserted
replaced
210 |
210 |
211 List constraints:: |
211 List constraints:: |
212 |
212 |
213 SELECT * FROM pg_constraint; |
213 SELECT * FROM pg_constraint; |
214 SELECT * FROM pg_constraint WHERE conrelid = (SELECT oid FROM pg_class WHERE relname LIKE 'tblName'); |
214 SELECT * FROM pg_constraint WHERE conrelid = (SELECT oid FROM pg_class WHERE relname LIKE 'tblName'); |
|
215 select * from pg_constraint where conname like '%conName%'; |
215 |
216 |
216 https://www.postgresql.org/docs/current/catalog-pg-constraint.html |
217 https://www.postgresql.org/docs/current/catalog-pg-constraint.html |
217 pg_constraint. |
218 pg_constraint. |
218 |
219 |
219 List functions:: |
220 List functions:: |