Re: [GENERAL] Import LDAP data to a Postgres database

2007-12-06 Thread Magnus Hagander 
On Thu, Dec 06, 2007 at 09:42:19AM +0100, Marco Curtolo wrote:
 
 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) ???

Depending on exactly what you nede to do, check out dblink-ldap
(http://pgfoundry.org/projects/dblink-ldap/)

//Magnus


---(end of broadcast)---
TIP 4: Have you searched our list archives?

   http://archives.postgresql.org/

Re: [GENERAL] Import LDAP data to a Postgres database

2007-12-06 Thread Albe Laurenz 
Marco Curtolo write:
 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) ???

Yes, by writing a function in C that uses the LDAP API.

Yours,
Laurenz Albe

---(end of broadcast)---
TIP 6: explain analyze is your friend

Re: [GENERAL] Import LDAP data to a Postgres database

2007-12-06 Thread Chris Browne 
[EMAIL PROTECTED] (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!

---(end of broadcast)---
TIP 6: explain analyze is your friend