select n.nspname ,c.relname,a.attname,t.typname,a.attlen--the same,t.typlen
from pg_class c
left join pg_namespace n on c.relnamespace=n.oid
left join pg_attribute a on c.oid =a.attrelid
left join pg_type t on t.oid =a.atttypid
where c.relname in ('prod_inst_acct_rel_aap_cp','prod_inst_acct_rel_aap_yj')
and attnum>0
and n.nspname='iodata_mz'
greenplum6查看表的字段类型
最新推荐文章于 2023-11-22 10:09:34 发布