Re: Doing an LDAP lookup from a SQL SELECT - Mailing list pgsql-general

From Magnus Hagander
Subject Re: Doing an LDAP lookup from a SQL SELECT
Date
Msg-id 4891D815.8010500@hagander.net
Whole thread Raw
In response to Doing an LDAP lookup from a SQL SELECT  (David R Robison <drrobison@openroadsconsulting.com>)
Responses Re: Doing an LDAP lookup from a SQL SELECT
List pgsql-general
David R Robison wrote:
> I have an LDAP directory that contains contact information and a
> PostgreSQL table that has contact names. What I want to do is write a
> SELECT that will join the names in the table with the data in the LDAP
> directory (such as phone number, e-mail address, etc). Is this possible?
> Has anyone done this before?

Take a look at dblink-ldap, available on pgFoundry. It's not exactly
polished :-), but it works for a lot of cases. I've used it for doing
exactly what you're trying to do here.

//Magnus


pgsql-general by date:

Previous
From: David R Robison
Date:
Subject: Doing an LDAP lookup from a SQL SELECT
Next
From: Bohdan Linda
Date:
Subject: Re: archive_timeout, checkpoint_timeout