Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group