Re: DB Links in Postgres?

Bruce Momjian wrote:
> Tomeh, Husam wrote:
> > The use of Dblink would be very helpful in our application. From my
> > research so far, I found that PostgreSQL does not support DB links.
> > Could you confirm? And if true, is that something on the todo list.
> > Also, how stable is the code in the contrib/ to use in production
> > environments. Is code in contrib stable and matured? And what makes
> > certain code candidate to be in contrib? (The reason I'm asking is that
> > I found that there's dblink code in contrib/dblink)..
>
> dblink is the only way we currently have to do cross-database queries.
> /contrib is as good as the main code in many cases.  Of course, _good_
> is a relative term.  :-)

The short answer is that dblink is regularly used in production, as is
most of /contrib and PostgreSQL itself.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073