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