Call Us: +1-888-227-1645

Updating PostgreSQL Driver Manually in PHPStorm

Recently I had to update PHPStorm’s PostgreSQL Driver manually as it was failing to read a project’s tables. Instead of seeing the all so familiar table names all I saw was the sequences where the tables should be seen.

Further observation of the database settings yielded no red flags. PHPStorm also had all its latest updates. At the time of writing the PostgrsSQL Driver was showing ver.42.2.5.

To correct this issue I took the following steps:

  • I removed all driver versions from the settings panel and restarted PHPStorm in order to have it detect the lack of drivers and download them again. However this did not help.

  • What worked instead was to manually download the latest postgresql-42.2.5.jar.

  • Navigate to ~usr/LibraryPreferences/PhpStorm[your-licensed-version]/jdbc-drivers/PostgreSQL (on Mac) and create a folder named “42.2.5” . Put the downloaded .jar in there.

  • Remove the old database connection in PhpStorm’s project workspace and create a new one. Make sure to select the “Current database” schema and “public(Current Schema)”. Test the connection and if it’s successful save it.

  • Restarting PHPStorm afterwards finally gave the desired result and started reading the database properly.

A detail to note: The database in question was initially set up with PostgreSQL 11.

Let's build something amazing together

Give us a ring and let us know how we can help you reach your goals. Or if you'd like, start a chat. We're usually available 9-5 EST. We try to respond to every inquiry within one business day.

Phone number
+1-888-227-1645

Technologies and services we work with:

Laravel Laravel
WordPress WordPress
React ReactJS
EmberJS EmberJS
woocommerce WooCommerce
next.js NextJS
gatsby Gatsby
Shopify Shopify
VueJs VueJS
contentful Contentful
next.js JAMStack
gatsby Laravel Jigsaw
WPEngine WP Engine
Laravel Livewire Laravel Livewire
Netlify Netlify