Tino Wildenhain <tino@xxxxxxxxxxxxx> 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
