sqoop查询关系型数据库表结构

sqoop eval 
--connect "jdbc:postgresql://ip:port/?currentSchema=public" 
--username hypers_swn 
--password hypers_swn_x3_l_2@1 
--query " select a.attnum,a.attname,concat_ws('',t.typname,SUBSTRINg(format_type(a.atttypid,a.atttypmod) from '(.*)')) as type
from pg_class c, pg_attribute a , pg_type t
where c.relname = 'tablename' and a.attnum>0 and a.attrelid = c.oid and a.atttypid = t.oid";