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