I am trying out some ideas using FDW, and I have added some FDW tables which access a backend MySQL DB... Unfortunately, I am getting some errors because of fields names with reserved words. I was wondering if there is a way to "alias" a field name when creating the foreign table?
Thanks in advance!!!
Deven
I'm not seeing where you've provided sufficient information for someone to help you.
From what I can tell there is not aliasing capability native to the FDW implementation so anything would have to be defined in OPTIONS for the table which is a wrapper-controlled structure.
Depending on the overall needs you typically can use reserved label as identifiers if you surround them with double-quotes.