MSSql Money Type - Value is not correct

[drauber]

Hello!

Anyone can help me about how i can migrate from Microsoft Sql Server to Postgresql database columns of type money?

I have few rows with round problem.

SqlServer says:
7082761.6900
2951150.7100
1770690.4200

But, Postgresql
7082761.5
2951150.8
1770690.4

I have run
docker run --rm dimitri/pgloader:latest pgloader mssql://sa:[email protected]/database postgresql://postgres:[email protected]/teste_douglas

I have tried with load file, and cast type money to "double precision" drop typemod;

but, the result is the same.

[drauber]

Now it works

docker run --rm -v /home/douglas:/data dimitri/pgloader:latest pgloader --load-lisp-file /data/custom.lisp /data/pgloader.load

files.zip

Attached files.