[asterisk-users] Access postgresql directly from dialplan?

Gertjan Baarda gertjan.baarda at gmail.com
Tue Apr 16 08:17:59 CDT 2013

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.


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

More information about the asterisk-users mailing list