Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

Next:From: Bohdan LindaDate: 2008-07-31 15:24:47
Subject: Re: archive_timeout, checkpoint_timeout
Previous:From: Alvaro HerreraDate: 2008-07-31 14:50:44
Subject: Re: archive_timeout, checkpoint_timeout

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group