Re: BUG #8901: postgres_fdw double-qualifying schemas

Stephen Frost <sfrost(at)snowman(dot)net> writes:
> * byteslayer7(at)gmail(dot)com (byteslayer7(at)gmail(dot)com) wrote:
>> I posted a question on Stackoverflow regarding postgres_fdw. I was advised
>> to report it here and link to it:
>> [...]
>> ) SERVER export_server OPTIONS (table_name 'export_schema.aa');
>> SELECT * FROM import_schema.aa;
>>
>> Which I expect to work, instead gives this error:

> Use: OPTIONS (schema_name 'export_schema' table_name 'aa'); above.

This is documented in the postgres_fdw reference page, but I notice that
page has absolutely no examples. A concrete example or two might help
perhaps. Anybody feel like working up a patch?

regards, tom lane