From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
---|---|
To: | Lane Holcombe <lane(at)cd-solutions(dot)net> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Server to server communication |
Date: | 2002-09-30 03:23:41 |
Message-ID: | 20020930032341.GA16166@svana.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)svana(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-09-30 03:53:59 | Re: [SQL] CURRENT_TIMESTAMP |
Previous Message | Lane Holcombe | 2002-09-30 03:21:39 | Server to server communication |