Re: Query to return data types

I want to query the precision and scale of all columns of numeric types. I see here 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?

Killian