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