View Single Post

   
  #4 (permalink)  
Old 04-16-2008, 12:56 AM
John R Pierce
 
Posts: n/a
Default 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)


---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Reply With Quote