Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group