想批量把包含bigint类型字段的表都改成numeric的

想批量把包含bigint类型字段的表都改成numeric的

想批量把包含bigint类型字段的表都改成numeric的

想批量把包含bigint类型字段的表都改成numeric的

SELECT n.nspname ,
    c.relname ,
    a.attname    ,
    t.typname    ,
    c.relkind
FROM pg_namespace n,
    pg_class c     ,
    pg_attribute a ,
    pg_type t
WHERE c.oid =a.attrelid
AND a.atttypid =t.oid
AND n.oid= c.relnamespace
AND relkind ='r'
AND t.typname ='int8'
复制