Thread: Database link
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 STRING TO 2ND DB/ALIAS>;
yep, FDWs, foreign data wrappers.
Regards,
Michael Vitale
Regards,
Michael Vitale
Friday, February 22, 2019 3:16 PMDoes 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 STRING TO 2ND DB/ALIAS>;