Dealing with multiple currencies with the money type?

From: Simon Connah <simon(dot)n(dot)connah(at)protonmail(dot)com>
To: "pgsql-novice(at)lists(dot)postgresql(dot)org" <pgsql-novice(at)lists(dot)postgresql(dot)org>
Subject: Dealing with multiple currencies with the money type?
Date: 2021-04-18 12:08:41
Message-ID: H6NwMbpHX0JnUKV8NN9e4CYJ3sT2zUGB5MJP9zXWSvnBh1J6VBRjxvGng2hBSM4iqknyr5p-jPBqoPOq_cOzoidn5gHKz4s9F-o1f1eGZdI=@protonmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi,

I've read this page:

https://www.postgresql.org/docs/13/datatype-money.html

which seems to suggest that lc_monetary dictates what currency the database uses for the money type. But what if you want to have transactions in USD, GBP and EUR from a database with en_GB.UTF8 locale?

Is this possible?

Simon.

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message David G. Johnston 2021-04-18 15:21:41 Re: Dealing with multiple currencies with the money type?
Previous Message Daniel Heath 2021-04-16 06:16:45 Re: Prepared statement invalidation