SELECT 
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' THEN 'BASE TYPE'
WHEN pt.typtype='e' THEN 'ENUMERATION TYPE'
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 IN ('pg_catalog') OR a.rolname<>'postgres')
AND pt.typtype IN ('b','e','r')
AND pt.typlen = -1
AND left(pt.typname,1)<>'_'
ORDER BY type_name, type_type;