Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <pgsql-sql-owner+archive@lists.postgresql.org>)
	id 1gxK8b-0006mK-37
	for pgsql-sql@arkaria.postgresql.org; Fri, 22 Feb 2019 23:21:49 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.89)
	(envelope-from <pgsql-sql-owner+archive@lists.postgresql.org>)
	id 1gxK8Z-0002YL-Og
	for pgsql-sql@arkaria.postgresql.org; Fri, 22 Feb 2019 23:21:47 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <MichaelDBA@sqlexec.com>)
	id 1gxK8Z-0002VY-I0
	for pgsql-sql@lists.postgresql.org; Fri, 22 Feb 2019 23:21:47 +0000
Received: from mout.perfora.net ([74.208.4.196])
	by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <MichaelDBA@sqlexec.com>)
	id 1gxK8X-00014o-AL
	for pgsql-sql@lists.postgresql.org; Fri, 22 Feb 2019 23:21:47 +0000
Received: from [192.168.1.101] ([98.169.208.73]) by mrelay.perfora.net
 (mreueus001 [74.208.5.2]) with ESMTPSA (Nemesis) id 0M1Ypb-1hHL5u14qf-00tTbc;
 Sat, 23 Feb 2019 00:21:39 +0100
Message-ID: <5C708403.7080800@sqlexec.com>
Date: Fri, 22 Feb 2019 18:21:39 -0500
From: MichaelDBA <MichaelDBA@sqlexec.com>
User-Agent: Postbox 5.0.25 (Windows/20180328)
MIME-Version: 1.0
To: MICHAEL LAZLO III <giantmetfan@comcast.net>
CC: pgsql-sql@lists.postgresql.org
Subject: Re: Database link
References: <2070566063.34453.1550866600553@connect.xfinity.com>
In-Reply-To: <2070566063.34453.1550866600553@connect.xfinity.com>
Content-Type: multipart/alternative;
 boundary="------------010708000800080303040708"
X-Provags-ID: V03:K1:VOWjzjLuoGbh0/QhEPNjAbonyUYn4FOrv6wdLgU0DwOjAm420tj
 4biWB8mCGGeSXEMVJKhi8c6WeF7o7kklaC7HCMQzFkTBD4Ej5D4P+f8+6DbyvnSHXstlInJ
 On5VRLdMf+V+emskI5n1SAfSLYTG1ATHyfImvW0Sm/tcNyG5aZf2j73CMTjXqiO+5wpd78Y
 fAbOBa/b2SBVp0VoM7+7A==
X-Spam-Flag: NO
X-UI-Out-Filterresults: notjunk:1;V03:K0:De4v/InuqxY=:c1vZibuv0JkM2eOOEjNAFP
 Ck0f7/MjFBCmPZ+TCxBig/dq2+p4Lj3fTmYpE6NZO7WWXek9nTAFCEtyCxyGIrpJ40Lz4HrFd
 bqm1YmfVozrn6l8sPf7MAKA5kFdIoEEkJg7bWlNYl4hYCqAjcNLQllKOPn15iS+8TBI11lj4N
 Zku9oOIlpVSBFd1lTKIRAAXZCij1wu9sGgdce2f4NzashGhu3wzDRPHPsZ9dPyDqpsG/FzOC6
 Ke0QvOvhOP1NOYB15vLvLL8+ACgm8CEOGjsIGQla8sM982R52f8ia/CqQ9COthXebzMnE6J6a
 RT9bTAY5toZz5ddCqRi7Z74olUlh+SIrIvGs+Ho4m9gRcY8axAkoIBGbir4zIJc92fO5TYF7m
 yOmTpbda4/GIU4ON8a5nRbIYz8bTApGD0ssgh/WoZInR9nKciGSDnjIOYSLxt+XvAPARcjY4s
 SWXkice9jjJYPhyRPHFN9cUu6GbwsOWsQtPdrrPrXu8EP+lWwqC+jS9LgbzMBqLoFk8qoPJEl
 MNxFLbNTxkHNGcbcMzDf+1WsLqZ7vS5utEQna1G0i97jjARVVrK/jO0+m/8r2K16vhpk4u2zj
 w60FkONdGr4TlS3lJsHks2MeKWzUHAawGuJ6wBIRpm7e2gyiIqxfaq/IPWBPxb3SXUcZgxUBo
 YlN9ekDwsxDb8pMVZp04puOu23qdbP0aPsOqb9/7KH7e4C7Nrgw5od3+vnam9F+/3iX5jniYN
 md3bFy/WdR3LANqpxU7xYujDX9DKfW09wLAA6fro8PiEV5tLgQC2uKl8XKU=
List-Id: <pgsql-sql.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-sql@lists.postgresql.org>
List-Owner: <mailto:pgsql-sql-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-sql>
Precedence: bulk

This is a multi-part message in MIME format.
--------------010708000800080303040708
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

yep, FDWs, foreign data wrappers.

Regards,
Michael Vitale

> MICHAEL LAZLO III <mailto:giantmetfan@comcast.net>
> 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>;
>


--------------010708000800080303040708
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit

<html><head>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
</head><body bgcolor="#FFFFFF" text="#000000">yep, FDWs, foreign data 
wrappers.<br>
<br>
Regards,<br>
Michael Vitale<br>
<span>

</span><br>
<blockquote style="border: 0px none;" 
cite="mid:2070566063.34453.1550866600553@connect.xfinity.com" 
type="cite">
  <div style="margin:30px 25px 10px 25px;" class="__pbConvHr"><div 
style="width:100%;border-top:2px solid #EDF1F4;padding-top:10px;">   <div
 
style="display:inline-block;white-space:nowrap;vertical-align:middle;width:49%;">
   	<a moz-do-not-send="true" href="mailto:giantmetfan@comcast.net" 
style="color:#485664 
!important;padding-right:6px;font-weight:500;text-decoration:none 
!important;">MICHAEL LAZLO III</a></div>   <div 
style="display:inline-block;white-space:nowrap;vertical-align:middle;width:48%;text-align:
 right;">     <font color="#909AA4"><span style="padding-left:6px">Friday,
 February 22, 2019 3:16 PM</span></font></div>    </div></div>
  <div style="color:#909AA4;margin-left:24px;margin-right:24px;" 
__pbrmquotes="true" class="__pbConvBody">

    <meta charset="UTF-8">
<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 moz-do-not-send="true" href="mailto:REMOTE_TABLE@"><connection>REMOTE_TABLE@&lt;CONNECTION</connection></a>
 STRING TO 2ND DB/ALIAS&gt;;<br></p></div>
</blockquote>
<br>
</body></html>

--------------010708000800080303040708--