Help for this page

Select Code to Download


  1. or download this
    -- versions 7.4 thru 9:
# select substring(version() from E'^PostgreSQL (\\S+)') ; 
...
 80404
(1 row)
  2. or download this
    perl -MDBI -e'my$dbh=DBI->connect("dbi:Pg:"); print $dbh->{pg_server_v
+ersion}, "\n"';
80404
  3. or download this
    select  implementation_info_name, character_value 
  from  information_schema.sql_implementation_info
...
 DBMS NAME                | PostgreSQL
 DBMS VERSION             | 08.04.0004
(2 rows)