[asterisk-users] postgres and asterisk

chester c young chestercyoung at yahoo.com
Fri Jan 5 20:37:21 MST 2007


use a simple agi - php is easy to do.


--- "O.Kamal" <okamalo at gmail.com> 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> 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
> >
> > _______________________________________________
> --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
> 


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 


More information about the asterisk-users mailing list