Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 1 down vote favorite

For example 2 DBases:

  1. DBMS Postgresql
  2. DBMS MySQL

In each DB include one DB and one table in it. Can I work with table in PostgreSQL through MySQL?

Is it possible to link as federated postgresql table to mysql database? For make insert/update/select/delete or join operations with such linked table.

I can link MySQL to MySQL by code below and make all operations.

CREATE TABLE `f_t21` ( 
`id` int(11) DEFAULT NULL, 
`name` varchar(255) DEFAULT NULL 
) ENGINE=FEDERATED DEFAULT CHARSET=latin1 CONNECTION='mysql://user:[email protected]:3306/db/table'

Can I link postgresql table of anyone postgresql version to someone mysql version? for it using as part of federated DB?

share|improve this question
Please have a look at stackoverflow.com/faq#howtoask and add a lot more detail or (if this question gets closed) post a new one with an appropriate level of detail. Include versions. Define "federated PostgreSQL table" since that isn't something that's part of the core PostgreSQL. Explain what the underlying problem you're trying to solve is. Define exactly what you mean by "attach" - like a foreign table (linked table)? A materialized view where it's periodically copied? What? – Craig Ringer Mar 27 at 11:07

migrated from stackoverflow.com Mar 28 at 23:35

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.