Perhaps the type of a base table column/domain should be BOOLEAN (based on CHECK constraints)

Copy SQL

WITH expressions AS (select 
n.nspname as schema,
c.relname || '.' || o.conname as name, 
substring(pg_get_constraintdef(o.oid),7) as expression,
'TABLE CHECK' as constraint_type,
at.typname as data_type
from pg_constraint o inner join pg_class c on c.oid = o.conrelid
inner join pg_namespace n on n.oid=c.relnamespace
inner join pg_attribute a on a.attnum=o.conkey[1] and a.attrelid=c.oid
inner join pg_type at on a.atttypid=at.oid
where o.contype ='c' 
and cardinality(o.conkey)=1
and n.nspname not in (select schema_name
from information_schema.schemata
where schema_name<>'public' and
schema_owner='postgres' and schema_name is not null) and at.typname<>'bool'
union select n.nspname as schema,
t.typname || '.' || o.conname as name, 
substring(pg_get_constraintdef(o.oid),7) as expression,
'DOMAIN CHECK' as constraint_type,
dt.typname as data_type
from pg_constraint o inner join pg_type t on t.oid = o.contypid
inner join pg_namespace n on n.oid=t.typnamespace
inner join pg_type dt on t.typbasetype=dt.oid
where o.contype ='c' and n.nspname not in (select schema_name
from information_schema.schemata
where schema_name<>'public' and
schema_owner='postgres' and schema_name is not null) and dt.typname<>'bool')
SELECT schema, name, expression, constraint_type, data_type
FROM expressions
WHERE (   
    expression ~* 'ANY[[:space:]]*[(]ARRAY[[][[:space:]]*['']?(0|1|true|false)\y['']?[^,\]]*[[:space:]]*,[[:space:]]*['']?(0|1|true|false)\y['']?[^,\]]*[]][)]' 
    OR     
    expression ~* '=[[:space:]]+(0|1)\y[)][[:space:]]+OR[[:space:]]+.+=[[:space:]]+(0|1)\y' 
    OR     
    expression ~* '(true|false)[^,]*[[:space:]]OR[[:space:]][^,]*(true|false)'
) AND name !~ '(arv|number|count|cnt)'
ORDER BY schema, constraint_type, name;