Question

Data Type

+28

How can I maintain the exact postgre data type of numeric , when write it back to database.

The image below is the database datatype (numeric) used used as a Reader but the above image is the writer output data type as numeric (1000,500)

+16

Hi @evoteck

I haven’t seen this before, but I’m happy to try figuring something out with you and the community!

I’m wondering if there could be something in the writer parameters. Would you be willing to share a screenshot of that?

Happy FME-ing!

+28

@desiree_at_safe I have been able to solve the issue of decimal by changing the data type to numeric (50, 0)

Evoteck Geospatial Consult

+16

That’s great! Thank you for sharing your solution, @evoteck

Happy FME-ing!

3 replies