[PHP-DB] pear db and pgsql

[rob caSSon]

i'm having a hell of a time figuring out how to connect to a postgresql
database using the pear db abstraction...here's some code snippets:

with mysql (works fine):

        require_once('DB.php');
        $db = DB::connect("mysql://username:password@localhost/audio");
        if (DB::isError($db)) {
                print $db->getMessage();
        }
        $select_query = "SELECT * FROM items";
        $result = $db->query($select_query);
        while ($row = $result->fetchRow()) {
                print "$row[1]<BR>";
        }
        $db->disconnect();


with pgsql (dies with this error: 
        DB Error: unknown error
        Fatal error: Call to undefined function: query() in /path/pg_test.php 
                on line 8)

        require_once('DB.php');
        $db = DB::connect("pgsql://username:password@localhost/audio");
        if (DB::isError($db)) {
                print $db->getMessage();
        }
        $select_query = "SELECT * FROM items";
        $result = $db->query($select_query);
        while ($row = $result->fetchRow()) {
                print "$row[1]<BR>";
        }
        $db->disconnect();

both databases exist, along with the tables....$10 says i'm being dumb, and need to 
put the port # someplace on the postgres connect, but i can't seem to put it in the 
right place.....

tia,
r


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]