select

case cls.relkind when 'r' then 'Tables' when 'v' then 'Views' when 'm' then 'Views' end as table_type,

ns.nspname as table_schema,

cls.relname as table_name,

attr.attname as column_name,

trim(leading '_' from tp.typname) as data_type,

case attr.attnotnull when true then 'NO' when false then 'YES' end as is_nullable

from

pg_catalog.pg_attribute as attr

join pg_catalog.pg_class as cls on cls.oid = attr.attrelid

join pg_catalog.pg_namespace as ns on ns.oid = cls.relnamespace

join pg_catalog.pg_type as tp on tp.typelem = attr.atttypid

where

cls.relkind in ('r', 'v', 'm')

and ns.nspname not in ('pg_catalog', 'pg_toast', 'information_schema')

and not attr.attisdropped

and attr.attnum > 0

order by

ns.nspname,

cls.relname,

attr.attnum