Skip to main content
Question

How do I prevent the Postgres Writer from naming all fields to lower case?

  • April 26, 2023
  • 1 reply
  • 32 views

kmc5678
Contributor
Forum|alt.badge.img+2

When I update the writer and uncheck "Lower Case Attribute Names" under Table Creation it automatically rechecks it after I close the window. I just want to retain the same field name format from the table I'm reading from.

1 reply

egge
Contributor
Forum|alt.badge.img+14
  • Contributor
  • May 9, 2023

Hi, I think it is some kind of a convention in PostgreSQL to have table names and field/column names in lower case, always. And it looks like the FME PostgreSQL Writer adheres to this convention: "The PostgreSQL writer module stores both geometry and attributes into an PostgreSQL database. Note that attributes are always written as lowercase."


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings