I want to query the precision and scale of all columns of numeric types. I see
to use information_schema.columns; I have done this, and for one schema (my db has three schemas) it works using:
SELECT column_name, data_type, numeric_scale, numeric_precision, numeric_precision_radix
FROM information_schema.columns
WHERE table_name = 't1'
ORDER BY ordinal_position;
This returns
"x";"numeric";10;20;10
"y";"numeric";10;20;10
"z";"numeric";4;10;10
If I query a table on another schema using:
SELECT column_name, data_type, numeric_scale, numeric_precision, numeric_precision_radix
FROM information_schema.columns
WHERE table_name = 't1b'
ORDER BY ordinal_position;
This returns
"area";"numeric";;;10
"latitude";"numeric";;;10
"longitude";"numeric";;;10
even though there should be an output for scale and precision.
How can I correctly query this?