Database Link between 2 PostgreSQL db

From: "Reuben D(dot) Budiardja" <techlist(at)voyager(dot)phys(dot)utk(dot)edu>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Database Link between 2 PostgreSQL db
Date: 2005-03-12 20:00:10
Message-ID: 200503121500.10680.techlist@voyager.phys.utk.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)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------

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Robby Russell 2005-03-12 20:19:15 Re: Database Link between 2 PostgreSQL db
Previous Message Tom Lane 2005-03-12 18:59:23 Re: Best practices: Handling Daylight-saving time