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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
