Postgres Pro
Downloads
Home   >   mailing lists

Dealing with multiple currencies with the money type? - Mailing list pgsql-novice

From Simon Connah
Subject Dealing with multiple currencies with the money type?
Date
Msg-id H6NwMbpHX0JnUKV8NN9e4CYJ3sT2zUGB5MJP9zXWSvnBh1J6VBRjxvGng2hBSM4iqknyr5p-jPBqoPOq_cOzoidn5gHKz4s9F-o1f1eGZdI=@protonmail.com
Whole thread Raw
Responses Re: Dealing with multiple currencies with the money type?  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-novice
Tree view 
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
wantto have transactions in USD, GBP and EUR from a database with en_GB.UTF8 locale? 

Is this possible?

Simon.
Attachment

pgsql-novice by date:

Previous
From: "Daniel Heath"
Date:
Subject: Re: Prepared statement invalidation
Next
From: "David G. Johnston"
Date:
Subject: Re: Dealing with multiple currencies with the money type?