Asterisk PGSQL

NOTE

This function is not available in asterisk. Either use ODBC or write this funtion.

Synopsis

Do several SQLy things 🙂

Syntax (Asterisk 1.2)

PGSQL(Connect var option-string)

Connects to a database. Option string contains standard PostgreSQL parameters like host=, dbname=, user=. Connection identifer returned in ${var}

PGSQL(Query var ${connection_identifier} query-string)

Executes standard SQL query contained in query-string using established connection identified by ${connection_identifier}. Reseult of query is is stored in ${var}.

PGSQL(Fetch statusvar ${result_identifier} var1 var2 … varn)

Fetches a single row from a result set contained in ${result_identifier}. Assigns returned fields to ${var1} … ${varn}. ${statusvar} is set TRUE if additional rows exist in reseult set.

PGSQL(Clear ${result_identifier})

Frees memory and datastructures associated with result set.

PGSQL(Disconnect ${connection_identifier})

Disconnects from named connection to PostgreSQL.

Examples

exten => s,2,PGSQL(Connect connid host=localhost user=asterisk dbname=credit)
exten => s,3,PGSQL(Query resultid ${connid} SELECT username,credit FROM credit WHERE callerid=${CALLERIDNUM})
exten => s,4,PGSQL(Fetch fetchid ${resultid} datavar1 datavar2)
exten => s,5,GotoIf(${fetchid}?6:8)
exten => s,6,Festival(“User ${datavar1} currently has credit balance of ${datavar2} dollars.”)
exten => s,7,Goto(s,4)
exten => s,8,PGSQL(Clear ${resultid})
exten => s,9,PGSQL(Disconnect ${connid})

See also

• Asterisk cdr pgsql: Writing CDR data to Postgres
• Asterisk cmd MYSQL
• Asterisk RealTime PostgreSQL