Turn off "money" formatting?

From: jerry(dot)levan(at)eku(dot)edu (Jerry)
To: pgsql-general(at)postgresql(dot)org
Subject: Turn off "money" formatting?
Date: 2004-06-06 20:44:26
Message-ID: 46850fd1.0406061244.75449fcb@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Is it possible to turn off the "$" and "," that appear in "money" formatted
columns so I can dump the table in a numeric format?

The man page hints that lc_monetary controls the formatting but I
cannot find any clues on what to do...

Apparently money cannot be cast to anything.

I don't think it will be hard to write a custom tcl/perl
script that takes a "copy checks to...." command to do the task
but I would like a cleaner solution....

Jerry

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2004-06-06 21:35:42 Re: statement level triggers in PostgreSQL , anybody??
Previous Message Jason Sheets 2004-06-06 20:04:13 Re: table content transfer from mysql to postgresql