Linking tables between DBM's

Archived Topics
1

Guys,

Is it possible to link tables between MySQL and Posrtgress?

2

Describe what you mean by “link tables” a bit more.

You can pull data in from two different datasources in FactoryPMI, but not in the same query (you can’t perform a JOIN between two different databases)

Is this what you are talking about?

3

I guess I’m wondering if the link feature (what you enter in 1 table is automactically updated in the other) that is available between Access and MySQL is available between Postgress and MySQL.

4

I think that’s a feature of MS Access. (Get External Data->Linked tables). I’m not familiar with any way of doing it and I didn’t see anything in the documentation.