Hi, when I import numeric data from a txt file (I define the data = double type in text struncture) in a table from postgres (data defined = numeric), in the table the data arrived truncated (without decimals). Please, could you help me with this issue?
If in postgres table I have type = numeric(10,2) and in flat file or in another table I have any numeric type, I can not import the decimals. Why?. If I change in postgres type in float(4) the decimals are imported but altered.