WITH domains_start AS (SELECT nspname AS domain_schema, t.typname AS domain_name, t.typnotnull AS not_null, t.typdefault AS def_value, 
string_agg(substring(pg_get_constraintdef(c.oid),7),';' ORDER BY substring(pg_get_constraintdef(c.oid),7)) AS constraints
FROM pg_catalog.pg_type t INNER JOIN pg_catalog.pg_namespace n ON t.typnamespace=n.oid
INNER JOIN pg_catalog.pg_constraint c ON t.oid=c.contypid
WHERE t.typtype='d' 
AND nspname NOT IN (SELECT schema_name
FROM INFORMATION_SCHEMA.schemata
WHERE schema_name<>'public' AND
schema_owner='postgres' AND schema_name IS NOT NULL)
GROUP BY nspname, t.typname, t.typnotnull, t.typdefault),
domains AS (SELECT domain_Schema, domain_name, not_null, def_value, constraints,
(SELECT CASE WHEN data_type='numeric' THEN data_type || '(' || numeric_precision || ',' || numeric_scale || ')'
WHEN character_maximum_length IS NOT NULL THEN data_type || '(' ||  character_maximum_length || ')'
WHEN datetime_precision IS NOT NULL AND data_type<>'date' THEN data_type || '(' ||  datetime_precision || ')'
ELSE data_type END AS data_type
FROM INFORMATION_SCHEMA.domains AS d WHERE domains_start.domain_schema=d.domain_schema AND domains_start.domain_name=d.domain_name) AS data_type
FROM domains_start),
duplicate_domains AS (SELECT data_type, not_null, def_value, constraints, array_agg(domain_schema || '.' || domain_name ORDER BY domain_schema, domain_name) AS domain_array
FROM domains
GROUP BY data_type, not_null, def_value, constraints
HAVING Count(*)>1)
SELECT format('DROP DOMAIN %1$s;', unnest(domain_array)) AS statements
FROM duplicate_domains
ORDER BY statements;