Re: Alias field names in foreign data wrapper?

On 03/27/2015 01:55 PM, Deven Phillips wrote:
> Better example of the problem... My FDW table schema is:
>
> CREATE FOREIGN TABLE liquorstore_backendipaddress (
>      id bigint NOT NULL,
>      backend_network_id bigint,
>      backend_virtual_interface_id bigint,
>      address character varying(15) NOT NULL,
>      is_gateway boolean NOT NULL,
>      is_reserved boolean NOT NULL
> )
> SERVER edison
> OPTIONS (
>      dbname 'edison',
>      table_name 'liquorstore_backendvirtualinterface'
> );
>
>
> But when I run the following query:
>
> SELECT
>      *
> FROM liquorstore_backendipaddress
>
> I get an error:
>
> ccedison=# SELECT * FROM liquorstore_backendipaddress;
> ERROR:  failed to prepare the MySQL query:
> Unknown column 'backend_network_id' in 'field list'

So is 'backend_network_id' in the MySQL table?

>
> I still cannot figure out what the problem might be so any help would be
> GREATLY appreciated.
>
> Thanks,
>
> Deven
>
> On Fri, Mar 27, 2015 at 4:15 PM, Deven Phillips
> <deven.phillips@gmail.com <mailto:deven.phillips@gmail.com>> wrote:
>
>     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
>
>


--
Adrian Klaver
adrian.klaver@aklaver.com