PowerDesigner 16.5 reverse PostgreSQL9.01 in unable to list the columns. SQLSTATE = 22003 Bad type value Short:t workaround

Database? Edit Current DBMS ... General tab? PostgreSQL 9.x? Script? Objects? Column? Sqllistquery

or Tools? Resource? Dbms? Postgresql9.x ... Ditto.

Replaced column in SELECT:

C.attnotnull

To:

CAST (Nullif (C.attnotnull,false) as VARCHAR (1))

Similarly in

... Script\objects\key\sqllistquery

Replaced column in SELECT:

X.indisprimary

To:

CAST (Nullif (X.indisprimary,false) as VARCHAR (1))

Note: http://www.cnblogs.com/ITbbs/p/4441693.html

PowerDesigner 16.5 reverse PostgreSQL9.01 in unable to list the columns. SQLSTATE = 22003 Bad type value Short:t workaround