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:
even though there should be an output for scale and precision.
How can I correctly query this?
I see what I did: I just queried where I had already declared the precision and scale.
What I actually want is to see is: which columns contain data with values that contain decimal points, and the max precision and scale of these values.