Re: Import LDAP data to a Postgres database

From: Chris Browne <cbbrowne(at)acm(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Import LDAP data to a Postgres database
Date: 2007-12-06 17:14:13
Message-ID: 60aboniw4a.fsf@dba2.int.libertyrms.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

marcoecommerce(at)hotmail(dot)it (Marco Curtolo) writes:
> Hi, my question is this: it is possible to query, using SQL, an LDAP
> server and put these data to a table of a Postgres database (under
> linux) ???

Unfortunately, the LDAP model is more or less a "network model," which
doesn't fit terribly elegantly onto SQL.

You can in fact use PostgreSQL as the backend for OpenLDAP; there's a
HOWTO on this:

<http://www.samse.fr/GPL/ldap_pg/HOWTO/>

There are also ways of exporting SQL data via LDAP; see here:

<http://www.openldap.org/faq/data/cache/378.html>
--
select 'cbbrowne' || '@' || 'linuxdatabases.info';
http://www3.sympatico.ca/cbbrowne/sap.html
Microsoft Outlook: Deploying Viruses Has Never Been This Easy!

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2007-12-06 17:24:44 Re: Avoid huge perfomance loss on string concatenation
Previous Message Tom Lane 2007-12-06 17:12:42 Re: Nested loop in simple query taking long time