Which PostgreSQL column type should be used to store a Java BigDecimal?

Question

What PostgreSQL column type should I use to store a Java BigDecimal? Answer See PostgreSQL datatypes - perhaps Numeric, which can act as an arbitrary precision type (this is a PostgreSQL extension). ...without any precision or scale creates a column in which numeric values of any precision and scale can be stored, up to the implementation limit on precision. I

Accepted Answer

See PostgreSQL datatypes &#8211; perhaps Numeric, which can act as an arbitrary precision type (this is a PostgreSQL extension).      &#8230;without any precision or scale creates a column in which numeric values of any precision and scale can be stored, up to the implementation limit on precision.  I am not entirely sure what &#8220;implementation limit on precision is&#8221;, though. Have never tried really large numbers. If the limit is reached, then a fallback to text is possible. But, I suspect there will be significant other issues before then 😉 If you wish to store less, then specify a precision and/or scale to numeric.Edit as sjr pointed out, the restriction is 1000 decimal digits of precision (from the same link):      The type numeric can store numbers with up to 1000 digits of precision [in currentl implementations] and perform calculations exactly. It is especially recommended for storing monetary amounts and other quantities where exactness is required&#8230;  If more precision is needed &#8211; despite having a much bigger problem at hand &#8211; then a numeric column will not be suitable (by itself). But this is really more of a very extreme &#8220;what if&#8221; and likely does not play a limiting role.

Advertisement

Answer