Database link
MICHAEL LAZLO III <[email protected]> Fri, 22 Feb 2019 21:16:40 +0100 (CET)
| Newsgroups | gmane.comp.db.postgresql.sql |
|---|---|
| Message-ID | <[email protected]> |
Does postgresql allow connectivity as Oracle does using database links? Which allows someone logged into 1 postgresql database to query a table in another postgresql database? The table in second database would have some sort of alias to allow something like this: SELECT * FROM REMOTE_TABLE@<CONNECTION mailto:REMOTE_TABLE@ STRING TO 2ND DB/ALIAS>;