12.7 The PostgreSQL Module

PostgreSQL is one of the first industrial-strength RDBMS, offering features comparable to those of all the major players at absolutely no cost. You can find more information about PostgreSQL at http://www.postgresql.org/.

 DB/pgsql.php <?php function db_connect($args=array()) {     return @pg_connect($args[0], $args[1], $args[2], $args[3], $args[4]); } function db_pconnect ($args=array()) {     return @pg_pconnect($args[0], $args[1], $args[2], $args[3], $args[4]); } function db_close($args=array()) {     return @pg_close($args[0]); } function db_select_db($args=array()) {     return(true); } function db_query($args=array()) {     return @pg_exec($args[0], $args[1]); } function db_db_query($args=array()) {     return db_query($args[0], $args[2]); } function db_fetchrow($args=array()) {     if ($args[2] == DB_GETMODE_ASSOC) {         return @pg_fetch_array($args[0], $args[1], PGSQL_ASSOC);     } elseif ($args[2] & DB_GETMODE_REG) {         return @pg_fetch_array($args[0], $args[1], PGSQL_NUM);     } else {         return @pg_fetch_array($args[0], $args[1]);     } } function db_prepare($args=array()) {     return db_simulate_prepare($args); } function db_execute($args=array()) {     $stmt = db_simulate_execute(&$args);     return db_query(array($stmt, array_shift ($args))); } function db_num_rows($args=array()) {     return @pg_numrows($args[0]); } function db_free_result($args=array()) {     return @pg_freeresult($args[0]); } function db_commit($args=array()) {     return(true); } function db_rollback($args=array()) {     return(true); } function db_autoCommit($args=array()) {     return($args[1]); } ?> 

Explanation

The PostgreSQL module ”like the MSSQL, MySQL, and mSQL modules before it ”is a simple wrapper for the PostgreSQL functions of the same names .