Page 1 of 1

how do i check which version postgre im running?

PostPosted: Thu Jul 09, 2009 3:47 am
by zubs1aa
how do i check which version postgre im running? I know it's 8.3 but not whther it's 8.3.x or y.

ANyone know?

THanks

Re: how do i check which version postgre im running?

PostPosted: Thu Jul 09, 2009 8:55 am
by kraada
Click Start --> Programs --> PostgreSQL --> psql to 'postgres'. At the prompt type:

SELECT version();

and hit enter. It will tell you on the resulting line what version you're running.

Re: how do i check which version postgre im running?

PostPosted: Thu Jul 09, 2009 11:16 am
by zubs1aa
kraada wrote:Click Start --> Programs --> PostgreSQL --> psql to 'postgres'. At the prompt type:

SELECT version();

and hit enter. It will tell you on the resulting line what version you're running.

Thanks-ez enough