postgres.rst
changeset 2337 c6c55f6a45c8
parent 2333 3a371f973644
child 2338 4837614fea35
equal deleted inserted replaced
2336:4cd18bed8bac 2337:c6c55f6a45c8
   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::