SELECT



        atab.attnum             as 列番,



        ttab.typname            as 表名,



        atab.attname            as 列名,



        atab.atttypid           as 型番,



        ttyp.typname            as 型名,



        atyp.attlen             as "LEN",



        atab.atttypmod-4        as 文字,



        (atab.atttypmod-4) / 65536 as 整数,



        (atab.atttypmod-4) % 65536 as 小数,







        atab.attnelems          as 配列,



        atab.attnotnull         as "NOT_NULL"



 



FROM    pg_class, 



        pg_type         ttyp, 



        pg_type         ttab, 



        pg_attribute    atab,



        pg_attribute    atyp



WHERE 



        ttab.typrelid   = atab.attrelid



    and atab.attnum     >= 0    -- oid,cmax等除外



    and pg_class.relkind = 'r'



    and ttab.typname    = pg_class.relname







    and atab.atttypid   = ttyp.oid



    and atab.oid        = atyp.oid







    and atyp.attnum > 0 



    and atyp.attrelid = pg_class.oid 



    and atyp.atttypid = ttyp.oid 







    and     ttab.typname    not like 'pg_%'  -- メタデーター除去



    -- and  pg_class.relname = 'ＤＢ表の名前' --特定の１表のみの時







ORDER BY 



        ttab.typname,



        atyp.attnum



;