Database link

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Database link

MICHAEL LAZLO III

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 [hidden email] STRING TO 2ND DB/ALIAS>;

Reply | Threaded
Open this post in threaded view
|

Re: Database link

Michaeldba@sqlexec.com
yep, FDWs, foreign data wrappers.

Regards,
Michael Vitale

Friday, February 22, 2019 3:16 PM

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 [hidden email] STRING TO 2ND DB/ALIAS>;