asterisk users - Apr 2013 - Access postgresql directly from dialplan?

I would like to access a Postgresql database directly from my dialplan 
(to lookup names based on callerid numbers for incoming calls). Based on 
everywhere I looked - it seems the only way to do this is with 
func_odbc. Considering that Asterisk seems to be able to access 
Postgresql databases directly using res_pgsql for the purposes of 
realtime functionality (without using odbc - if I understand correctly) 
- is there some other generic SQL dialplan function which would allow 
access to the Postgresql database from the dialplan without configuring 
ODBC and the rest?

Or does anybody know of a simpler way still to do this? My database is a 
Horde address book backend - which is in Postgresql - so I would like to 
use it to convert the incoming callerid's into names on the fly from the 
Horde address book.

On 16 apr. 2013, at 15:08, Sebastian Arcus <shop at open-t.co.uk> wrote:
> I would like to access a Postgresql database directly from my dialplan (to
lookup names based on callerid numbers for incoming calls). Based on everywhere
I looked - it seems the only way to do this is with func_odbc. Considering that
Asterisk seems to be able to access Postgresql databases directly using
res_pgsql for the purposes of realtime functionality (without using odbc - if I
understand correctly) - is there some other generic SQL dialplan function which
would allow access to the Postgresql database from the dialplan without
configuring ODBC and the rest?
>
> Or does anybody know of a simpler way still to do this? My database is a
Horde address book backend - which is in Postgresql - so I would like to use it
to convert the incoming callerid's into names on the fly from the Horde
address book.

AGI is your new friend. Google it. I use it for your the same purpuses
as you want with PHP and Mysql.
With a macro I change the callerid in a name from the DB.

greetz

Sent from my iPhone
> __________________________________________________________________
> -- Bandwidth and Colocation Provided by http://www.api-digital.com --
> New to Asterisk? Join us for a live introductory webinar every Thurs:
>              http://www.asterisk.org/hello
>
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
>  http://lists.digium.com/mailman/listinfo/asterisk-users