Postgres Pro
Downloads
Home   >   mailing lists

Thread: querying PostgreSQL version?

querying PostgreSQL version?

From
Zlatko Matić
Date:
Hello.
 
Is there any way to check the version of PostgreSQL by a query? Maybe by querying catalog tables?
Thanks,
 
Zlatko

Re: querying PostgreSQL version?

From
Rodrigo Gonzalez
Date:
select version()<br /><br /> Zlatko Matić wrote: <blockquote cite="mid000101c5da2e$9b1d32e0$0123fea9@zlatkovyfkpgz6"
type="cite"><style></style><div><fontface="Arial" size="2">Hello.</font></div><div> </div><div><font face="Arial"
size="2">Isthere any way to check the version of PostgreSQL by a query? Maybe by querying catalog
tables?</font></div><div><fontface="Arial" size="2">Thanks,</font></div><div> </div><div><font face="Arial"
size="2">Zlatko</font></div></blockquote>

Re: querying PostgreSQL version?

From
Peter Wiersig
Date:
On Wed, Oct 26, 2005 at 02:52:36PM +0200, Zlatko Matić wrote:
>
> Is there any way to check the version of PostgreSQL by a query?
> Maybe by querying catalog tables?

Easier: select version();

Peter

Re: querying PostgreSQL version?

From
Sean Davis
Date:
On 10/26/05 8:52 AM, "Zlatko Matić" <zlatko.matic1@sb.t-com.hr> wrote:

> Hello.
>
> Is there any way to check the version of PostgreSQL by a query? Maybe by
> querying catalog tables?

Select version();

Re: querying PostgreSQL version?

From
"A. Kretschmer"
Date:
am  26.10.2005, um 14:52:36 +0200 mailte Zlatko Mati? folgendes:
> Hello.
>
> Is there any way to check the version of PostgreSQL by a query? Maybe by querying catalog tables?
> Thanks,

select version();


HTH, Andreas
--
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47212,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
 ===    Schollglas Unternehmensgruppe    ===

Re: querying PostgreSQL version?

From
Terry Lee Tucker
Date:
rnd=# select version();
                                                   version
--------------------------------------------------------------------------------------------------------------
 PostgreSQL 7.4.6 on i686-redhat-linux-gnu, compiled by GCC gcc (GCC) 3.2.3
20030502 (Red Hat Linux 3.2.3-49)
(1 row)

On Wednesday 26 October 2005 08:52 am, Zlatko Matić saith:
> Hello.
>
> Is there any way to check the version of PostgreSQL by a query? Maybe by
> querying catalog tables? Thanks,
>
> Zlatko

Re: querying PostgreSQL version?

From
"A. Kretschmer"
Date:
am  26.10.2005, um 10:22:27 -0300 mailte Rodrigo Gonzalez folgendes:
> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
> <html>
> <head>
>   <meta content="text/html;charset=ISO-8859-2" http-equiv="Content-Type">
> </head>
> <body bgcolor="#ffffff" text="#000000">
> select version()<br>
> <br>
> Zlatko Mati? wrote:
> <blockquote cite="mid000101c5da2e$9b1d32e0$0123fea9@zlatkovyfkpgz6"
>  type="cite">
>   <meta http-equiv="Content-Type" content="text/html; ">
>   <meta content="MSHTML 6.00.2900.2769" name="GENERATOR">
>   <style></style>
>   <div><font face="Arial" size="2">Hello.</font></div>
>   <div> </div>
>   <div><font face="Arial" size="2">Is there any way to check the
> version of PostgreSQL by a query? Maybe by querying catalog tables?</font></div>
>   <div><font face="Arial" size="2">Thanks,</font></div>
>   <div> </div>
>   <div><font face="Arial" size="2">Zlatko</font></div>
> </blockquote>
> </body>
> </html>

Please, no HTML!


Thanks, Andreas
--
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47212,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
 ===    Schollglas Unternehmensgruppe    ===

Re: querying PostgreSQL version?

From
Larry Rosenman
Date:
On Oct 26, 2005, at 7:52 AM, Zlatko Matić wrote:

> Hello.
>
> Is there any way to check the version of PostgreSQL by a query?
> Maybe by querying catalog tables?
> Thanks,

select version();

>
> Zlatko
>

--
Larry Rosenman                     http://www.lerctr.org/~ler
Phone: +1 214-351-4152                 E-Mail: ler@lerctr.org
US Mail: 3535 Gaspar Drive, Dallas, TX 75220-3611