You can access the PostgreSQL shell using a GUI client such as pgAdmin or using psql: Using SQL shellĪnother way to determine the version of the PostgreSQL server is to log in to the server SQL query and use the SQL instruction to print the version. Psql is an interactive command-line utility that allows you to interact with the PostgreSQL server.
#Postgresql client windows command keygen
![postgresql client windows command postgresql client windows command](https://www.wikihow.com/images/4/48/Watch-Star-Wars-on-Command-Prompt-Step-5-Version-2.jpg)
The version of the psql client utility in PostgreSQL can be found with the following command: Once you find the path to the binary file, you can use it to get a version of the PostgreSQL server: Sudo find /usr -wholename '*/bin/postgres'. You can find the path to the binary with the locate or find command: This usually happens when PostgreSQL package is not installed from standard distribution repositories. If the Postgres binary file is absent in the system PATH, you will get the error message “Postgres: command not found”. This example uses the PostgreSQL server version 10.6. The command will print the PostgreSQL version: To find out which PostgreSQL version works on your system, call the Postgres command with the -version or -V parameter: Each major release is supported for 5 years. Major PostgreSQL releases with new features are usually released once a year. For example, 11.4 and 11.6 are minor versions, which are part of PostgreSQL version 11 9.6.15, and 9.6.16 are part of PostgreSQL version 9.6.
![postgresql client windows command postgresql client windows command](https://inthetechpit.files.wordpress.com/2019/01/ubuntu-feature-win.jpg)
MINOR – The minor release number is the last part of the version number.Prior to PostgreSQL 10, the major versions were represented by a decimal number, such as 9.0 or 9.6. MAJOR – Starting with PostgreSQL 10, each new major release increases a part of the MAJOR version by one, for example by 10, 11, or 12.PostgreSQL has versions in the following scheme:įor example, in PostgreSQL 12.1 12 is the main version and 1 is the additional version.