Re: BUG #8901: postgres_fdw double-qualifying schemas - Mailing list pgsql-bugs

* 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;
>=20
> Which I expect to work, instead gives this error:=20

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

    Thanks,

        Stephen