CODEWITHSUNDEEP
linuxpostgresqljdbcdriver
agaios
agaios

Reputation: 13

What is the command to check the version of the postgresql jdbc driver on Linux command line?

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?

Upvotes: 1

Views: 12152

Answers (2)

user330315
user330315

Reputation:

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.

Upvotes: 3

Laurenz Albe
Laurenz Albe

Reputation: 246718

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.

Upvotes: 2

Related Questions