[asterisk-users] postgres and asterisk

[Paul]

Start by writing some agi in perl or php. Either of those should allow
you to access pg database servers. If the agi is too slow for your needs
move it over to compiled c.

O.Kamal wrote:

> I just need to retrieve a value from a field in a postgres database,
> and playback this value when someone dial a specific extension.
>
> On 1/4/07, *Thomas Kenyon * <digium at sanguinarius.co.uk
> <mailto:digium at sanguinarius.co.uk>> wrote:
>
>     O.Kamal wrote:
>     > I need to retrieve my asterisk to retrieve a values from
>     postgresql, i
>     > am looking for some sort of application like *mysql*() app, I
>     found one
>     > but it is only available on Suse, is there any way for doing this?
>     >
>     > Regards,
>     > O.Youssef
>     >
>     What do you need to do?
>     To get an SQL console with postgres you need to:
>
>     psql -d <database name to start in> -U <username to connect as>
>
>     ie:
>
>     psql -d asterisk -U asterisk
>
>     The location of psql is different depensing upon distribution but
>     usually it's in either /usr/bin/psql or /usr/local/pgsql/bin/psql.
>
>     I'm not sure if this is what you want, if you want a pretty GUI
>     front-end then you could look at Pgadmin III (www.pgadmin.org
>     <http://www.pgadmin.org>) which
>     will run on Windows 2000/XP/2003 or unix/linux running X and requires
>     wxWindows and a pile of common libraries.
>     _______________________________________________
>     --Bandwidth and Colocation provided by Easynews.com
>     <http://Easynews.com> --
>
>     asterisk-users mailing list
>     To UNSUBSCRIBE or update options visit:
>        http://lists.digium.com/mailman/listinfo/asterisk-users
>
>
>------------------------------------------------------------------------
>
>_______________________________________________
>--Bandwidth and Colocation provided by Easynews.com --
>
>asterisk-users mailing list
>To UNSUBSCRIBE or update options visit:
>   http://lists.digium.com/mailman/listinfo/asterisk-users
>  
>