Skip to main content
  • EN

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)

 

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?

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

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

Community Stats

31,897
Posts
121,119
Replies
39,512
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.