Date: Fri, 22 Feb 2019 21:16:40 +0100 (CET)
From: MICHAEL LAZLO III <giantmetfan@comcast.net>
Reply-To: MICHAEL LAZLO III <giantmetfan@comcast.net>
To: pgsql-sql@lists.postgresql.org
Message-ID: <2070566063.34453.1550866600553@connect.xfinity.com>
Subject: Database link
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_34452_1821487661.1550866600551"
Importance: Medium
Precedence: bulk

------=_Part_34452_1821487661.1550866600551
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit

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>;

------=_Part_34452_1821487661.1550866600551
MIME-Version: 1.0
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit

<!DOCTYPE html>
<html><head>
    <meta charset="UTF-8">
</head><body><p style="font-size: 12pt; font-family: helvetica, arial, sans-serif; color: rgb(51, 51, 51);">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:<br></p><p style="font-size: 12pt; font-family: helvetica, arial, sans-serif; color: rgb(51, 51, 51);"><br></p><p style="font-size: 12pt; font-family: helvetica, arial, sans-serif; color: rgb(51, 51, 51);">SELECT * FROM <a href="mailto:REMOTE_TABLE@"><connection>REMOTE_TABLE@&#60;CONNECTION</connection></a> STRING TO 2ND DB/ALIAS&#62;;<br></p></body></html>
 
------=_Part_34452_1821487661.1550866600551--