What posgresql version am I using ?

[agunet74]

How can I know what postgresql version am I using ?
OR mysql version ?

Where are those data ?

thanks,

best regards

agunet

[ab@novell.com]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

rpm -qf `which psql` (assuming psql is in your path)

Google for: postgresql version

When you find the first hit notice the following in there:

select version();

That probably works from within the client.

Good luck.





agunet74 wrote:
> How can I know what postgresql version am I using ?
> OR mysql version ?
>
> Where are those data ?
>
> thanks,
>
> best regards
>
> agunet
>
>
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.9 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iQIcBAEBAgAGBQJK9B39AAoJEF+XTK08PnB5F4sP/1U0ZMZ0AEo9Nnmgv4kGxMWd
LsAHiBGrIHRqUojqnB+gTS+VSNrrf+RmaTTTNqP6kqrWmepqVd/x9xsmTTYn7c/L
9me3Cn5pGdMx4KozoTq8dhSnHe9rblLKZeRCaWkBwIPSuR7jW3 dwtoT+tHOO8A1G
XJOZZitxu7Fu6MdxB9TTPaDmvtswkoYOtmLVGbitfumzPt+p9E yyZPRc4DqUtdq1
g5OfDACYcfb0d9WvUZZjveYRGmVKm59VwHZi+pRmJJoxBTqqkp L9MPRiB8cyHXo/
CYFhkJWhz55bl52gGzFtx1PKMLEgIhldf8fKFbfcgdmKxwyB1o iPWxoaUjUTOfh5
bgIJcaHHGJlU2pWCXFguW+vWsplddQN26B1Fxm49zpnCp1RcS1 ALv5CNFWCcEbPN
XKMme8/Q5/017QzE4xX6x47uG7avWhSWQ7OAQC/qISOMHvqJDy0Vsn5qfrQuAK1Q
qiYPnm+oBC8R7B0UxB9Gy3lIADSy71zMUDvTZbg9xQEwZcXtVx 8aoG5tTYh25m+z
0IAd8P1PcI9RX/rmy3Fp4uMcD7M0/9bUtMdAeZTtOhwR4CHnjUHmOLVkoDfWWSjB
os4mPpFi46nW42pFhuL+x/ieBGwvYt4y0zV83eF76pXZlndYeTsosAZmQ30FhpBQ
4maJ3QZf4prlKq8fEs5J
=TeAU
-----END PGP SIGNATURE-----

[agunet74]

Ok that works !!

But now..

How do I make the same (know the versions )for mysql, php (how do I know the file I have to look for ?)

thanks

[ab@novell.com]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

The RPM option will work for anything installed via RPM. The first hit
from Google for me was:

http://dev.mysql.com/doc/refman/5.0/...n-version.html

and the first hit from Google for PHP:

http://blogs.reliablepenguin.com/ind...ne_php_version

Good luck.





agunet74 wrote:
> Ok that works !!
>
> But now..
>
> How do I make the same (know the versions )for mysql, php (how do I
> know the file I have to look for ?)
>
> thanks
>
>
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.9 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iQIcBAEBAgAGBQJK9ZOoAAoJEF+XTK08PnB5LB8P/0766qloCX052d5eH8BAUdch
wy6ItXWr0u2WW7qtTpMofGOSveI4duDbHOUBxy+B5TmyEUhijC nAPjy05L9rIaIz
FhilcxjVTOZJskImaAqvy8gn/VLxC+zOyzXCab10adle0fkk11YWPt8AXrLFv8IP
kiJQgX/9wqYSEwpiUfPq3zI2TTKRXCTYIzPUvUUAYX7k05W5q6OHW7GDX ULYrghZ
KKiuDPvEUAfs5nxQ+aeMlTdrGBF1uMzWu4yA9/WOGzIjavf0eKId+c76Y5e0GR73
uu+v7aOGYtnfebTIImq8mp8R0Tnx6cYfwrG6FYND28YTA2+CNn GilThuPhEAapau
ntE+QqTv2uloog0jlrdmMiGGtvfDk0m5RDAsJ/yiY95BWAJAmfCRA1TewgLA75a2
gmXGK+t+kJYaKhJg+VyPAZ4aYVsOQ5rTJKgGT5hYcq7Ytx4pgj DUVzFYHmmcVyLS
O3igv4Mi9cz0zrE8jxuS8rFt52KdE4sBiYJMOsdW5MePOfIDee fYgNCWk+gZxBHq
rqB/y14wnWW4ha7OC1Rlmbvt8y/D5t5AZHcfAidiHYnjOzLjSukLB6dNq526lSyq
PDKPDNqYvsO1LCPNtsmK7xL00LnJfUhoMEOQfpR87Aa9rNlaAZ MlqScMNoVmMNje
CcyBNeigG78uZ+Ufx9Bl
=3ui/
-----END PGP SIGNATURE-----

[agunet74]

Ok!
Thanks a lot !