I am working on Linux server with PostgreSQL that is installed through the command line.
How could I check the version of the PostgreSQL JDBC Driver using Linux command line?
I use this command psql -V and it shows the PostgreSQL version psql (PostgreSQL) 9.5.24, but I need the PostgreSQL JDBC Driver version. What is the command the should I use?
When you run:
java -jar /path/to/driver.jar
it will report its version.
Obviously you need to replace /path/to/driver.jar with the correct location where you stored the driver when you downloaded it.
By default the file name itself contains the version. So if you downloaded postgresql-42.2.19.jar then it's highly likely its version is 42.2.19
As a side note: psql -V prints the version of the command line tool. That's not necessarily the same version as the server.
From Java, you can use code like this:
java.sql.Driver d = new org.postgresql.Driver();
System.out.println(d.getMajorVersion() + "." + d.getMinorVersion());
See the documentation for details.