Re: In or Exists?

Fabrice.Sznajderman@devoteam.com wrote:
>
> thank you for your answer!
>
>
> how I can know the version of my postgres DataBase ?
> I know is 7.3.x but I don't know for the 'x' number ..

$ psql --version
psql (PostgreSQL) 8.1.2
...



or...

$ psql --version
psql (PostgreSQL) 7.4.5

(two different machines here)


this just shows the version of psql itself, which SHOULD be the same as
your server version.  if you want to confirm this,

$ psql -c "show server_version;"
  server_version
----------------
  7.4.5
(1 row)