[asterisk-users] postgres and asterisk

[O.Kamal]

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> 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) 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 --
>
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20070104/82060752/attachment.htm