how do i check which version postgre im running?

[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

[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.

[zubs1aa]

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