How To Check Postgresql Version

How to check postgresql version linux How to check postgresql version linux. How to check postgresql version linuxHow to install and connect to postgresql on ubuntu 18 04.

Here s how you might check your PostgreSQL version psql V This should return something like this psql PostgreSQL 13 3 The number after PostgreSQL is the version number Moreover being aware of your PostgreSQL version lets you leverage newer features and improvements How to check the postgresql database version in linux linux tutorial hub. How to check postgresql version linuxResboomer blog.

How to check postgresql version linux

How To Check PostgreSQL Version Linux

To find out what version of PostgreSQL is running on your system invoke the postgres command with the version or V option postgres version The command will print the PostgreSQL version postgres PostgreSQL 10 6 In this example the version of the PostgreSQL server is 10 6 Option 1: SELECT version () If you're already connected to PostgreSQL, run the following query to return the PostgreSQL server's version information: SELECT version (); Here's the result when using PostgreSQL 12.1:

How to check if postgres is installed on a linux system systran box

How To Check If Postgres Is Installed On A Linux System Systran Box

How To Check Postgresql VersionViewing the server version To find the Postgres server version from the shell command line, simply issue a postgres command with the -V flag (for version): $ postgres -V postgres (PostgreSQL) 9.3.10 In the event that the postgres command is not found, you may need to locate the directory of the utility. 21 Answers Sorted by 2045 Run this query from PostgreSQL SELECT version Share Improve this answer Follow edited Oct 24 2017 at 3 42 answered Dec 5 2012 at 22 42 Highly Irregular 38 4k 12 52 70 5 No result in my case in terminal on Ubuntu Timo Jul 9 2014 at 9 04 33