Look for dblink(). It's part of contrib/ IIRC. The new 7.3 version is much
better and was described just recently on this list. Search the archives.
On Sun, Sep 29, 2002 at 10:21:39PM -0500, Lane Holcombe wrote:
> Is it possible to cause an instance of pgsql to communicate with another
> instance on a remote server and then retreive a resultset?
>
> mssql offers a technique (OPENQUERY) which allows a stored procedure to use
> this functionality.
>
> I imagine that postgresql would use a similar technique, or possibly a "shell"
> feature to execute an operating system command which would then log into the
> remote server and perform such a function.
>
> I imagine this because I can't seem to find any reference to this feature.
>
> Please point me in the right direction.
>
> Thanks
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
> There are 10 kinds of people in the world, those that can do binary
> arithmetic and those that can't.