How to get the list of postgres check constraints of a table?

Postgres check Constraints can be retrieved via pg_catalog.pg_constraint.

SELECT con.*

       FROM pg_catalog.pg_constraint con

            INNER JOIN pg_catalog.pg_class rel

                       ON rel.oid = con.conrelid

            INNER JOIN pg_catalog.pg_namespace nsp

                       ON nsp.oid = connamespace

       WHERE nsp.nspname = ''

             AND rel.relname = '';

Replace with the name of your schema and

Upvote 0

Downvote 0