I have a postgres database (v9.6) and I have multiple CHECK
constraints that use user-defined functions.
something like:
CREATE TABLE payment (
amount bigint,
CONSTRAINT amount_gt_0 CHECK (round_amount(amount) > 0)
);
where round_amount
is user-defined function.
Is it possible to get a list of all constraint or at least tables that use such constraints?
postgresql version is 9.6