Re: Libpq in C Language Function - Mailing list pgsql-novice

From Joshua Tolley
Subject Re: Libpq in C Language Function
Date
Msg-id 4c5c13fc.20d7720a.40ea.666e@mx.google.com
Whole thread Raw
In response to Libpq in C Language Function  ("Carel Combrink" <s25291930@tuks.co.za>)
List pgsql-novice
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

Attachment

pgsql-novice by date:

Previous
From: "Carel Combrink"
Date:
Subject: Libpq in C Language Function
Next
From: Joshua Tolley
Date:
Subject: Re: Best way to test/develop lots of nested functions?