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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

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: Thu, 31 Jul 2008 17:19:49 +0200
  • Message-id: <4891D815.8010500@hagander.net> <text/plain>

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




Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group