1

I was developing a web application with Codeigniter 3 framework with PostgreSQL. It's an eCommerce website and the currency we used globally is Indian Rupee.

I was using data type 'money' for the field where we store the price. Now we are about to upload the application to AWS RDS & EC2 and after creating a PostgreSQL database, the currency symbol shown is $.

I am pretty new to PostgreSQL and we already migrated all our data to the server. I would appreciate if someone will help me to change locale from $ to ₹ in PostgreSQL.

Jerry Jones
  • 776
  • 1
  • 13
  • 29
  • [Don't use the `money` type](https://wiki.postgresql.org/wiki/Don%27t_Do_This#Don.27t_use_money). The problem you are having is just one of the disadvantages. –  May 03 '19 at 20:17
  • 1
    Possible duplicate of [Set lc\_monetary for PostgreSQL](https://stackoverflow.com/questions/54064945/set-lc-monetary-for-postgresql) – Jorge Campos May 03 '19 at 20:27
  • @JorgeCampos Is there any way I can change it permanently for PostgreSQL? – Jerry Jones May 03 '19 at 20:46

0 Answers0