I DID get a foreign table to work using the following: CREATE FOREIGN TABLE customer ( id BIGINT, name VARCHAR(150), parent_id BIGINT, oracle_id BIGINT, last_updated_time TIMESTAMP, created_time TIMESTAMP) SERVER mysql OPTIONS (dbname 'mydb', table_name 'customer');
And I was subsequently able to query that table from PostgreSQL.. I tried to add the "OPTIONS" to the IMPORT FOREIGN SCHEMA and got an error that "dbname" is not a valid parameter. Thanks, Deven On Fri, Jan 8, 2016 at 11:38 PM, Deven Phillips <deven.phill...@gmail.com> wrote: > 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 >> > >
