| From: | MichaelDBA <MichaelDBA(at)sqlexec(dot)com> |
|---|---|
| To: | MICHAEL LAZLO III <giantmetfan(at)comcast(dot)net> |
| Cc: | pgsql-sql(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Database link |
| Date: | 2019-02-22 23:21:39 |
| Message-ID: | 5C708403.7080800@sqlexec.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
yep, FDWs, foreign data wrappers.
Regards,
Michael Vitale
> MICHAEL LAZLO III <mailto:giantmetfan(at)comcast(dot)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>;
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | github kran | 2019-02-25 22:59:22 | PostgreSQL DB Maintenance and Partitioning to keep data longer. |
| Previous Message | MICHAEL LAZLO III | 2019-02-22 20:16:40 | Database link |