On Fri, Aug 06, 2010 at 03:36:40PM +0200, Carel Combrink wrote:
> Hi,
>
> Is it possible to connect to another database from within a database.
> The 2 databases will probably not be on the same computer.
>
> Is it possible to create a C LANGUAGE function that connects to another
> database using libpq? I have tried this but after calling PQconnectedb
> the status returned by PQstatus is CONNECTION_BAD.
It sounds like you want dblink.
http://www.postgresql.org/docs/current/static/dblink.html
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com