Alias field names in foreign data wrapper?

From: Deven Phillips <deven(dot)phillips(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Alias field names in foreign data wrapper?
Date: 2015-03-27 20:15:24
Message-ID: CAJw+4NBqqxroxNC9M6C4pUwam=n6iM4o9cZGRtut2Fni3EWuQQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Deven Phillips 2015-03-27 20:16:38 Re: json-patch support?
Previous Message David G. Johnston 2015-03-27 20:07:50 Re: Building JSON objects