Skip to main content
Question

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

  • April 26, 2023
  • 1 reply
  • 69 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."