Re: DB Links in Postgres? - Mailing list pgsql-admin

From Bruce Momjian
Subject Re: DB Links in Postgres?
Date
Msg-id 200511150336.jAF3a1v29803@candle.pha.pa.us
Whole thread Raw
In response to Re: DB Links in Postgres?  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: DB Links in Postgres?
Next
From: Tim Allen
Date:
Subject: Re: Major Problem, need help! Can't run our website!