[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