Turn off "money" formatting? - Mailing list pgsql-general

From jerry.levan@eku.edu (Jerry)
Subject Turn off "money" formatting?
Date
Msg-id 46850fd1.0406061244.75449fcb@posting.google.com
Whole thread Raw
Responses Re: Turn off "money" formatting?  (Brendan Jurd <blakjak@blakjak.sytes.net>)
Re: Turn off "money" formatting?  (Karel Zak <zakkr@zf.jcu.cz>)
List 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

pgsql-general by date:

Previous
From: "Jason Sheets"
Date:
Subject: Re: table content transfer from mysql to postgresql
Next
From: Martijn van Oosterhout
Date:
Subject: Re: statement level triggers in PostgreSQL , anybody??