Re: change data type 'money' to '€' - Mailing list pgsql-novice

From Tom Lane
Subject Re: change data type 'money' to '€'
Date
Msg-id 11702.1309479136@sss.pgh.pa.us
Whole thread Raw
In response to change data type 'money' to '€'  (Mäggi Hieber <mhieber@sunrise.ch>)
List pgsql-novice
=?ISO-8859-15?Q?M=E4ggi_Hieber?= <mhieber@sunrise.ch> writes:
> In our project table we have a column with costs, using data typ
> "money". By default PostgreSQL always applys '$', but we would like to
> have '�'.
> How can I change the data type "money" (currency) of a column in an
> existing table to '�'?

See the lc_monetary setting (you'll need to have an installed system
locale setting that does what you want).

            regards, tom lane

pgsql-novice by date:

Previous
From: Thom Brown
Date:
Subject: Re: Help with SQL staterment
Next
From: Chris Campbell
Date:
Subject: Re: Help with SQL staterment