>Just go into MS SQL and try creating a DTS job to migrate from MS SQL to
>Pgsql. Have both fields (in ms and pg) be of type money. In the
>destination the field type will show up as float4 instead of money. If you
>try executing the job it will bomb saying that it is sending data in the
>wrong format (or something to that effect [i forget]).
Hello,
I had this problem before:
1) Try foat8 which is the normal mapping for money,
2) Make sure the local format of number are the same
Example : SQL Server 100.000,00 FHT --> PostgreSQL US $100,000.00 will not
work.
Regards,
Jean-Michel POURE