Timeline for Attaching database to an existing connection
Current License: CC BY-SA 4.0
8 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Oct 11, 2020 at 17:48 | comment | added | nbk | as always give it a try, federated tables are tables, that are mirrored local copies of tables from other servers and you can access it like it was on your server and use them in selct views or what you need | |
| Oct 11, 2020 at 16:17 | comment | added | Igor |
from that link The postgres_fdw module provides the foreign-data wrapper postgres_fdw, which can be used to access data stored in external PostgreSQL servers.. I presume federated tables for mySQL is also a remote server thing. Does this mean that I can't access second db on the same server? And what about Sybase/Oracle?
|
|
| Oct 10, 2020 at 20:14 | history | edited | nbk | CC BY-SA 4.0 |
added 103 characters in body
|
| Oct 10, 2020 at 20:14 | comment | added | nbk | mysql has fedrated tables postgresql postgresql.org/docs/9.3/postgres-fdw.html, this makes an external datasource available in the host system, so that yu can use it. directly, but as i explained before, when you want to mix tow dofferent connections, you make a select in one and on the other connection you make alo a select and then compare them, or update them | |
| Oct 10, 2020 at 20:05 | comment | added | Igor |
IIUC, when I estabish a connection to the DB server I either have to supply a db name or issue use <db_name>, therefore all queries will be going into this specific database. What I'm looking for is get the information from another DB without disconnecting. One connection handle - 2 DB. AFAIK, only SQLite (ATTACH command) and MS SQL Server (CREATE DATABASE...FOR ATTACH command). Then I can use the appropriate syntax. Are you saying all other DBMSes support something like this? If yes - how? I know PostgreSQL didn't have a notion of attached db - didn't support it.
|
|
| Oct 10, 2020 at 17:58 | comment | added | nbk | you are talikng abut twi servers, with seperated connections, i expanded my answer | |
| Oct 10, 2020 at 17:52 | history | edited | nbk | CC BY-SA 4.0 |
added 392 characters in body
|
| Oct 10, 2020 at 17:05 | history | answered | nbk | CC BY-SA 4.0 |