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?
The money type should largely be avoided. I find it useful for parsing external data but in the end store money using numeric. Add a currency type field if you need to be explixit about what units the currency is in.