Database Link between 2 PostgreSQL db - Mailing list pgsql-general

From Reuben D. Budiardja
Subject Database Link between 2 PostgreSQL db
Date
Msg-id 200503121500.10680.techlist@voyager.phys.utk.edu
Whole thread Raw
Responses Re: Database Link between 2 PostgreSQL db  (Robby Russell <robby@planetargon.com>)
List pgsql-general
Hello,
Oracle has a concept of Database link, IE you can access data from a table in
different database, even if the database is in different host, using
something like

SELECT * FROM table@REMOTE_CONNECT;

Is there something similar in PostgreSQL? I would like to know if I can access
my data on a remote PostgreSQL server from a local PostgreSQL database.

Thank you in advance for any respond.

RDB
--
Reuben D. Budiardja
Dept. Physics and Astronomy
University of Tennesse, Knoxville, TN

-----BEGIN GEEK CODE BLOCK-----
Version: 3.12
GIT/M/MU/P/S d-(++) s: a-- C++(+++) UL++++ P-- L+++>++++ E- W+++
N+ o? K- w--- !O M- V? !PS !PE Y PGP- t+ 5 X R- tv+
b++>+++ DI D(+) G e++>++++ h+(*) r++ y->++++
------END GEEK CODE BLOCK------

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Best practices: Handling Daylight-saving time
Next
From: Robby Russell
Date:
Subject: Re: Database Link between 2 PostgreSQL db