Re: Doing an LDAP lookup from a SQL SELECT

From: Magnus Hagander <magnus(at)hagander(dot)net>
To: David R Robison <drrobison(at)openroadsconsulting(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Doing an LDAP lookup from a SQL SELECT
Date: 2008-07-31 15:19:49
Message-ID: 4891D815.8010500@hagander.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bohdan Linda 2008-07-31 15:24:47 Re: archive_timeout, checkpoint_timeout
Previous Message Alvaro Herrera 2008-07-31 14:50:44 Re: archive_timeout, checkpoint_timeout