Quick Links

change data type 'money' to '€'

From:	Mäggi Hieber <mhieber(at)sunrise(dot)ch>
To:	pgsql-novice(at)postgresql(dot)org
Subject:	change data type 'money' to '€'
Date:	2011-06-30 15:15:23
Message-ID:	4E0C930B.5050900@sunrise.ch
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-novice

Hello

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 '€'?

Thanks a lot!
Mäggi

Responses

Re: [NOVICE] change data type 'money' to '€' at 2011-06-30 20:02:51 from Ognjen Blagojevic
Re: change data type 'money' to '€' at 2011-06-30 20:34:51 from Jean-Yves F. Barbier
Re: change data type 'money' to '€' at 2011-07-01 00:12:16 from Tom Lane

Browse pgsql-novice by date

	From	Date	Subject
Next Message	Jean-Yves F. Barbier	2011-06-30 15:44:05	Re: Locking out a user after several failed login attempts
Previous Message	Vincent Ficet	2011-06-30 13:49:53	Re: pg_advisory_locks in a multithreaded application context