Create the object:
	For security reasons it's good practice to have this in a
	conf file outside the DOCUMENT_ROOT 

	$db = new mod_pgsql();
	$db->connect(DB_HOST, DB_PORT, DB_DATABASE, DB_USER, DB_PASS);	

SELECT statement:
	The result is written into a array (in this case a associative array)

	$qs = "SELECT * from table";
	$res = $db->select($qs);

INSERT, UPDATE DELETE:
	These statements are all encapsulated in a transaction. Therfore, we put
	the statements into a array and then call the transaction method. If the
	transaction is commited it returns true and if not false.

	$qs = " INSERT INTO table (id, data) VALUES ({$id}, '{$data}')";
	$db->sql_add($qs);

	$qs = " UPDATE table SET data = '{$new_data}' WHERE id = {$id}";
	$db->sql_add($qs);

	$qs = " DELETE FROM table WHERE id = {$id}";
	$db->sql_add($qs);

	$db->transaction();
	
PREPARED STATEMENT:
	Let's say we have a lot of INSERT statements which we fire within a
	foreach loop. Generally, using a prepared statement is helping to
	improve performance.

	$qs = " INSERT INTO table (id,data) VALUES ($1, $2)";
	$db->prepare($qs, 'prep_name');

	foreach($data_array as $k => $v) {
		$db->execute('prep_name', array($k, $v));
	}		
	
	Using prepared statements with a SELECT statement is also supportetd. If
	using SELECT use the fetch() methjod to recieve a result array

	$qs = " SELECT data FROM table WHERE id = $1";
	$db->prepare($qs, 'prep_name');

	$result_array = array();
	foreach($id_array as $v) {
		$res_id = $db->execute('prep_name', array($v['id']));
		$result_array[] = $db->fetch($res_id);
	}