一、数据库连接
powerdesigner需要安装32位jdk,同时到 Tool -> General Options中设置32位jdk的路径
配置数据库连接:
选择菜单 Database -> Update Model From Database,弹出对话框
二、错误:Unable to list the columns. SQLSTATE = 22003不良的类型值 short : t
选择 Database -> Edit Current DBMS,修改Script - Objects - Column - SqlListQuery
1、c.attnotnull 替换为 CAST(NULLIF(c.attnotnull,false) as VARCHAR(1))
2、 x.indisprimary 替换为 CAST(NULLIF(x.indisprimary,false) as VARCHAR(1))
三、adsrc 列不存在
(select adsrc::varchar from pg_attrdef f where f.adrelid = t.oid and f.adnum = c.attnum)::varchar 替换为 ''