Обсуждение: querying PostgreSQL version?
Hello.
Is there any way to check the version of PostgreSQL by a query? Maybe by querying catalog tables?
Thanks,
Zlatko
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>
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
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();
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 ===
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
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 ===
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