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: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice

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!


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-2017 The PostgreSQL Global Development Group