Apparently not, though I have done so in the past on PostgreSQL 9.4. It appears to be related to the "schema" with which the foreign table is associated:
mydb=# CREATE FOREIGN TABLE customer ( id BIGINT, name VARCHAR(150), parent_id BIGINT, oracle_id BIGINT, last_updated_time TIMESTAMP, created_time TIMESTAMP) SERVER mysql; CREATE FOREIGN TABLE mydb=# SELECT * FROM customer; ERROR: failed to prepare the MySQL query: Table 'public.customer' doesn't exist Any suggestions would be greatly appreciated! Deven On Fri, Jan 8, 2016 at 10:26 AM, Adrian Klaver <adrian.kla...@aklaver.com> wrote: > On 01/08/2016 07:04 AM, Deven Phillips wrote: > >> Hi all, >> >> I installed the newly released PostgreSQL 9.5 this morning and >> compiled the latest mysql_fdw extension from EnterpriseDB. I was able to >> create the SERVER and USER MAPPING, but I cannot seem to get IMPORT >> FOREIGN SCHEMA to do anything. The command executes without error, but >> none of the table schemas are imported from the MySQL DB. Does anyone >> have any advice, links, documentation which might be of help? >> > > Can you CREATE FOREIGN TABLE and use it? > > >> Thanks in advance! >> >> Deven >> > > > -- > Adrian Klaver > adrian.kla...@aklaver.com >
