PostgreSQL: create table script: wrong data type numeric
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
Create a table like
create table t(
value numeric(5, 2)
);
Then, use 'Scripts - Create Table Script', you get:
CREATE TABLE "mySchema"."t"
(
value numeric(19)
)
;
There is a bug with numeric data types. In the created script you find 'numeric(19)' instead of 'numeric(5, 2)'.
This affects at least versions 3.6 and 3.5.3.
Fixed in our Git repository. Will be fixed in future snapshots and versions.