Re: Extracting data from deprecated MONEY fields - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: Extracting data from deprecated MONEY fields
Date
Msg-id 4848AD51.2020605@commandprompt.com
Whole thread Raw
In response to Extracting data from deprecated MONEY fields  ("Ken Winter" <ken@sunward.org>)
Responses Re: Extracting data from deprecated MONEY fields  ("Ken Winter" <ken@sunward.org>)
List pgsql-general
Ken Winter wrote:
> I understand from
> http://www.postgresql.org/docs/8.0/static/datatype-money.html that the
> “money” data type is deprecated.

Money is no longer deprecated in newer releases (specifically 8.3),
although I do think it would be wise to push it to numeric.

I think the way to do it would be to backup the table and edit the table
definition from the file. Make the money a numeric. Then reload the
table from the backup.

Sincerely,

Joshua D. Drake

pgsql-general by date:

Previous
From: "Ken Winter"
Date:
Subject: Extracting data from deprecated MONEY fields
Next
From: "Gurjeet Singh"
Date:
Subject: Re: Annoying messages when copy sql code to psql terminal