Re: IMPORT FOREIGN SCHEMA statement - Mailing list pgsql-hackers

From Petr Jelinek
Subject Re: IMPORT FOREIGN SCHEMA statement
Date
Msg-id 53849B77.1060303@2ndquadrant.com
Whole thread Raw
In response to Re: IMPORT FOREIGN SCHEMA statement  (Ronan Dunklau <ronan.dunklau@dalibo.com>)
List pgsql-hackers
On 27/05/14 13:49, Ronan Dunklau wrote:
>> Between this and the type-mapping questions, it seems likely that
>> we're going to need a way for IMPORT FOREIGN SCHEMA to accept
>> user-supplied control options, which would in general be specific
>> to the FDW being used.  (Another thing the SQL committee failed to
>> think about.)
>
> So, without extending the syntax too much, we could add options:
>
> IMPORT FOREIGN SCHEMA remote_schema FROM SERVER server_name INTO local_schema
> [ { LIMIT TO | EXCEPT } (table_name [, ...])]
> [ OPTIONS (option_list) ]
>
> This option list could then contain fdw-specific options, including type
> mapping.


This one looks like good option to me.


--  Petr Jelinek                  http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training &
Services



pgsql-hackers by date:

Previous
From: Stephen Frost
Date:
Subject: Re: IMPORT FOREIGN SCHEMA statement
Next
From: Alvaro Herrera
Date:
Subject: Re: IMPORT FOREIGN SCHEMA statement