Postgres Pro
Downloads
Home   >   mailing lists

Thread: HwTo Foreign tables anybody?

HwTo Foreign tables anybody?

From
Frank Lanitz
Date:
Hi folks,

I'm looking for a HowTo of Foreign Tables feature. We are thinking of
connecting two postgres databases via this way and I wanted to try
before I do say yes or no ;) However, I didn't find any good HowTo on
via §search_engine.

Cheers,
Frank

Re: HwTo Foreign tables anybody?

From
Ian Lawrence Barwick
Date:
2013/3/8 Frank Lanitz <frank@frank.uvena.de>:
> Hi folks,
>
> I'm looking for a HowTo of Foreign Tables feature. We are thinking of
> connecting two postgres databases via this way and I wanted to try
> before I do say yes or no ;) However, I didn't find any good HowTo on
> via §search_engine.

If it's postgres_fdw you're looking for, it's a new feature and will
be available
with the next 9.3 release.

These blog posts might be of interest:

http://michael.otacoo.com/postgresql-2/postgres-9-3-feature-highlight-postgres_fdw/
http://www.postgresonline.com/journal/archives/294-PostgreSQL-9.3-postgres_fdw-a-Test-Drive.html


HTH

Ian Barwick