Re: Database link

MichaelDBA <[email protected]> Fri, 22 Feb 2019 18:21:39 -0500

Newsgroups	gmane.comp.db.postgresql.sql
Message-ID	<[email protected]>

yep, FDWs, foreign data wrappers.

Regards,
Michael Vitale

> MICHAEL LAZLO III <mailto:[email protected]>
> 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 REMOTE_TABLE@<CONNECTION <mailto:REMOTE_TABLE@> STRING 
> TO 2ND DB/ALIAS>;
>