Stephen Frost <sfrost@snowman.net> writes:
> * byteslayer7@gmail.com (byteslayer7@gmail.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