Thread: How to get the server version??

Hi

Is there any way, possible an SQL or pgsql command, to get the server version?

Thank you

Roberto

select version();


>From: Roberto Jo�o Lopes Garcia <roberto@mha.com.br>
>To: pgsql-sql@postgresql.org
>Subject: [SQL] How to get the server version??
>Date: Tue, 24 Jul 2001 10:50:50 -0300
>
>Hi
>
>Is there any way, possible an SQL or pgsql command, to get the server 
>version?
>
>Thank you
>
>Roberto
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster


_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

From: "Roberto João Lopes Garcia" <roberto@mha.com.br>

> Is there any way, possible an SQL or pgsql command, to get the server
version?

select version();


- Richard Huxton

On Tue, Jul 24, 2001 at 10:50:50AM -0300, Roberto Jo?o Lopes Garcia wrote:
> Hi
> 
> Is there any way, possible an SQL or pgsql command, to get the server version?
> 



template1=# select version();                            version                            
---------------------------------------------------------------PostgreSQL 7.1.2 on i686-pc-linux-gnu, compiled by GCC
2.95.4
(1 row)

Ross