PostgreSQL查询表中的字段，注释，字段类型

SELECT 
    a.attname as "字段名",
    col_description(a.attrelid,a.attnum) as "注释",
    concat_ws('',t.typname,SUBSTRING(format_type(a.atttypid,a.atttypmod) from '\(.*\)')) as "字段类型"
FROM 
    pg_class as c,
    pg_attribute as a, 
    pg_type as t
WHERE 
    c.relname = 'd_cross_stage' 
    and a.atttypid = t.oid 
    and a.attrelid = c.oid 
    and a.attnum>0