Re: Determing Postgres version

On Mon, 17 Dec 2001, Gary Hoffman wrote:

> Well, I thought of that.
>
> Here's what I get:
> ERROR:  function version() does not exist
>
> Any other ideas, short of actually asking the ISP help desk?

I just did it and it worked fine:

        $query = "select version()";

        $res = pg_exec($conn,$query);
        if(!$res) {
                die("not found");
        }

        if(($x = pg_numrows($res)) < 1) {
                echo("not found in database\n");
                exit;
        }

        $row = pg_fetch_row($res,$ii);
        echo("version: $row[0]");


and it gives:

version: PostgreSQL 7.1.2 on i386-unknown-freebsd4.2, compiled by GCC 2.95.2

Maybe it's really old?


Vince.
--
==========================================================================
Vince Vielhaber -- KA8CSH    email: vev@michvhf.com    http://www.pop4.net
         56K Nationwide Dialup from $16.00/mo at Pop4 Networking
        Online Campground Directory    http://www.camping-usa.com
       Online Giftshop Superstore    http://www.cloudninegifts.com
==========================================================================