Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

postgresql recommended data type for money

I am building an app for estimate and invoicing. This app will be able to export or integrate with accounting software.

For PostgreSQL which data type would you recommend? and if NUMERIC, what do you recommend for precision & scale settings?

like image 910
virtualbis Avatar asked Jun 20 '26 21:06

virtualbis


1 Answers

numeric(12,2) it is then.

Thanks everyone. New to stackoverflow but loving it so far.

like image 128
virtualbis Avatar answered Jun 22 '26 11:06

virtualbis



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!