select  implementation_info_name, character_value 
  from  information_schema.sql_implementation_info
 where  implementation_info_name ~ 'DBMS';

 implementation_info_name | character_value 
--------------------------+-----------------
 DBMS NAME                | PostgreSQL
 DBMS VERSION             | 08.04.0004
(2 rows)