agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedDatabase Link
3+ messages / 3 participants
[nested] [flat]
* Database Link
@ 2000-09-07 11:27 Gerhard Dieringer <DieringG@eba-haus.de>
0 siblings, 0 replies; 3+ messages in thread
From: Gerhard Dieringer @ 2000-09-07 11:27 UTC (permalink / raw)
To: " <"<pgsql-sql@postgresql.org>
A question for the postgreSQL gurus:
Some RDBMSs, for example Oracle, have a feature named 'Database Link' -
at least in Oracle - It's something like a view, thats lets you access a table,
that is located within another DB.
AFAIK, postgreSQL doesn't have this feature. Are there any plans to implement
it in the (near) future?
Gerhard
^ permalink raw reply [nested|flat] 3+ messages in thread
* Database link
@ 2019-02-22 20:16 MICHAEL LAZLO III <giantmetfan@comcast.net>
0 siblings, 1 reply; 3+ messages in thread
From: MICHAEL LAZLO III @ 2019-02-22 20:16 UTC (permalink / raw)
To: pgsql-sql@lists.postgresql.org
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>;
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Database link
@ 2019-02-22 23:21 MichaelDBA <MichaelDBA@sqlexec.com>
parent: MICHAEL LAZLO III <giantmetfan@comcast.net>
0 siblings, 0 replies; 3+ messages in thread
From: MichaelDBA @ 2019-02-22 23:21 UTC (permalink / raw)
To: MICHAEL LAZLO III <giantmetfan@comcast.net>; +Cc: pgsql-sql@lists.postgresql.org
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>;
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2019-02-22 23:21 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-09-07 11:27 Database Link Gerhard Dieringer <DieringG@eba-haus.de>
2019-02-22 20:16 Database link MICHAEL LAZLO III <giantmetfan@comcast.net>
2019-02-22 23:21 ` Re: Database link MichaelDBA <MichaelDBA@sqlexec.com>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox