Re: Alias field names in foreign data wrapper?

Поиск
Список
Период
Сортировка
От Deven Phillips
Тема Re: Alias field names in foreign data wrapper?
Дата
Msg-id CAJw+4NCw1UDfO1yPQ_WmsUfGO4_4FDCeQ=VgEGRUQ7N04h0ekg@mail.gmail.com
обсуждение исходный текст
Ответ на Alias field names in foreign data wrapper?  (Deven Phillips <deven.phillips@gmail.com>)
Ответы Re: Alias field names in foreign data wrapper?
Re: Alias field names in foreign data wrapper?
Список pgsql-general
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'

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> 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

В списке pgsql-general по дате отправления:

Предыдущее
От: Deven Phillips
Дата:
Сообщение: Re: json-patch support?
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: Alias field names in foreign data wrapper?