querying PostgreSQL version?
Hello.
Is there any way to check the version of PostgreSQL by a query? Maybe by querying catalog tables?
Thanks,
Zlatko
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
<!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>
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 ===
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();
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:
Show quoted text
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