Ben Stringer <ben@magicrock.net> writes:
> I'm trying to migrate several tables from a 6.5.2 DB to a
> 7.0.2 DB, and having trouble casting money (in the old DB)
> to numeric(10,2) prior to doing a pg_dump.
Hm. It doesn't seem that there is a cast path from money to anything,
even in latest sources. You might have to resort to dumping the table
as-is, then editing the dump file to change the column type from money
to numeric in the CREATE TABLE (and edit out all the dollar signs and
commas in the data, too). Ugh.
regards, tom lane