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: David R Robison <drrobison(at)openroadsconsulting(dot)com>
  • To: Magnus Hagander <magnus(at)hagander(dot)net>
  • Cc: pgsql-general(at)postgresql(dot)org
  • Subject: Re: Doing an LDAP lookup from a SQL SELECT
  • Date: Thu, 31 Jul 2008 12:56:40 -0400
  • Message-id: <4891EEC8.3080803@openroadsconsulting.com> <text/plain>

Thanks, I found the extension but no documentation on how to install it or use it. Can you give me some pointers? TNX David

Magnus Hagander wrote:
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



--

David R Robison
Open Roads Consulting, Inc.
708 S. Battlefield Blvd., Chesapeake, VA 23322
phone: (757) 546-3401
e-mail: drrobison(at)openroadsconsulting(dot)com
web: http://openroadsconsulting.com
blog: http://therobe.blogspot.com
book: http://www.xulonpress.com/book_detail.php?id=2579

This e-mail communication (including any attachments) may contain confidential and/or privileged material intended solely for the individual or entity to which it is addressed. If you are not the intended recipient, you should immediately stop reading this message and delete it from all computers that it resides on. Any unauthorized reading, distribution, copying or other use of this communication (or its attachments) is strictly prohibited. If you have received this communication in error, please notify us immediately.






Home | Main Index | Thread Index

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