Il 29/07/19 02:46, Karen Goh ha scritto:
[...]
But, my database is residing in version 10, not 7. So, I really need to just upgrade the psql.exe to version 10. Actually I don’t know why psql is version 7 and the server for my database is in 10.


Is the 10 you just downloaded the *only* PostgreSQL installation on your system? If you downloaded and installed it from one of the installers provided by partners there should be no version differences (not even with a 7.x, that goes back more than 10 years ago). I'm starting to suspect you have 2 PostgreSQL installations on your system and you're running psql from the wrong \bin folder.

What's the output when you connect via psql?


Cheers

Moreno