SELECT 
n.nspname AS type_schema, 
pt.typname AS type_name,
CASE WHEN pt.typstorage='p' THEN 'plain'
WHEN pt.typstorage='e' THEN 'external'
WHEN pt.typstorage='m' THEN 'main'
WHEN pt.typstorage='x' THEN 'extended'
END AS toasting_strategy,
CASE WHEN pt.typtype='b' AND left(pt.typname,1)<>'_' THEN 'BASE TYPE'
WHEN pt.typtype='b' AND left(pt.typname,1)='_' THEN 'ARRAY TYPE'
WHEN pt.typtype='e' THEN 'ENUMERATION TYPE'
WHEN pt.typtype='c' THEN 'COMPOSITE TYPE'
WHEN pt.typtype='d' THEN 'DOMAIN'
WHEN pt.typtype='r' THEN 'RANGE TYPE' END AS type_type
FROM pg_namespace AS n INNER JOIN pg_authid AS a ON n.nspowner=a.oid
INNER JOIN pg_type AS pt ON n.oid=pt.typnamespace
WHERE (n.nspname ='public' OR a.rolname<>'postgres')
AND pt.typtype IN ('b','d', 'e','r', 'c')
AND pt.typlen = -1
ORDER BY type_type, type_schema, type_name;