Thread: Libpq in C Language Function

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.

--
Carel Combrink
s25291930@tuks.co.za

This message and attachments are subject to a disclaimer. Please refer
to www.it.up.ac.za/documentation/governance/disclaimer/ for full
details. / Hierdie boodskap en aanhangsels is aan 'n vrywaringsklousule
onderhewig. Volledige besonderhede is by
www.it.up.ac.za/documentation/governance/disclaimer/ beskikbaar.

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