Handle "money" data type properly

Open talos opened this issue 10 years ago • 1 comments

This dataset has a "money" typed column which is filled with values starting with "$", which makes pgloader barf (and take forever.)

Clearly suboptimal to default these to a text type, anyway to tell one from the other?

Jul 15 '15 20:07 talos

For now these are all being inferred as "text".

One idea would be to peak at the downloaded CSV using python and do a type comparison.

Jul 20 '15 12:07 talos