Tino Wildenhain <tino@wildenhain.de> writes:
>> to_char() and back to numeric shouldn't be a problem within the database
>> and we have regex too if anything fails. I don't think you need to
>> dump and edit the dump to achive that.
> Ah sorry forget that... neither to_char nor cast to text works. Really a
> horrible datatype :(
If you do it within plpgsql it should work. Just assign the money value
to a text variable (or vice versa).
regards, tom lane