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.
How do I prevent the Postgres Writer from naming all fields to lower case?
Userlevel 1
+11
- Contributor
- 99 replies
-
9 May 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."
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.