How to get PostgreSQL version using PHP functions

Question

How do I get PostgreSQL and TOMCAT version using PHP functions. Please help me.

tres.14159 · Accepted Answer · 2014-07-23 15:51:23Z

4

I have found in this link Re: Determing Postgres version and the code is

$sql = "SELECT version();";
pg_send_query($dbconnection, $sql);

And my machine returns

PostgreSQL 8.4.20 on i386-redhat-linux-gnu, compiled by GCC gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-4), 32-bit

answered Jul 23, 2014 at 15:51

tres.14159

9282 gold badges20 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

codaddict · Accepted Answer · 2011-11-22 03:07:20Z

3

You can use pg_version to find the PostgreSQL version.

To find the Tomcat varsion you can open the file catalina.out and search for the pattern:

Apache Tomcat/<version>

A typical example is:

Apache Tomcat/6.0.13

answered Nov 22, 2011 at 2:59

codaddict

457k83 gold badges501 silver badges537 bronze badges

Need to check using PHP functions only...Please

Apache Tomcat? It is only for java, the question is about PHP.