Re: change data type 'money' to '€'

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Mäggi Hieber <mhieber(at)sunrise(dot)ch>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: change data type 'money' to '€'
Date: 2011-07-01 00:12:16
Message-ID: 11702.1309479136@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

=?ISO-8859-15?Q?M=E4ggi_Hieber?= <mhieber(at)sunrise(dot)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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Chris Campbell 2011-07-01 01:41:15 Re: Help with SQL staterment
Previous Message Thom Brown 2011-06-30 23:28:31 Re: Help with SQL staterment