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.

See also

• Asterisk cmd pgsql: Link page
• Asterisk cdr pgsql: Writing CDR data to Postgres
• Asterisk cmd mysql
• Asterisk RealTime PostgreSQL