Skip to main content
Question

Data Type

  • August 26, 2025
  • 3 replies
  • 96 views
evoteck
Enthusiast
Forum|alt.badge.img+31

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)

 

Evoteck Geospatial Consult

    3 replies

    desiree_at_safe
    Safer
    Forum|alt.badge.img+21

    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!
      evoteck
      Enthusiast
      Forum|alt.badge.img+31
      • evoteckEnthusiast
      • Author
      • Enthusiast
      • September 4, 2025

      ​@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
        desiree_at_safe
        Safer
        Forum|alt.badge.img+21

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

        Happy FME-ing!

          Community Stats

          32,737
          Posts
          124,174
          Replies
          41,235
          Members
          Terms & ConditionsAccessibility 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.