Software update: pgAdmin 4 6.4

You can use pgAdmin to manage PostgreSQL databases. This is a very comprehensive database manager that can be used under various operating systems, including Linux and Windows. The developers released version 6.4 of pgAdmin 4 a few days ago and the main changes and improvements made to it are listed below:

Features:

• Added support to import/export server groups and servers from GUI.
  This feature allows the users to export server definitions (and their groups) to a JSON file and re-imported them to the same or a different system to enable easy pre-configuration of pgAdmin. Previously this could be done using the ‘setup.py’ command-line script but after the implementation of this new feature it can be done using the Import/Export Servers Wizard.

Bugs/Housekeeping:

• Port Maintenance, and Restore dialog in React.
• Fixed an issue where Explain Analyze shows negative exclusive time.
• Fixed an issue where Columns with default value not showing when adding a new row.
• Fixed an issue where the Owner is not displayed in the reverse engineering SQL for Procedures.
• Fixed an issue where an operation error message pop up showing the database object’s name incorrectly.
• Fixed an issue where SubPlans may overlap other nodes & make them inaccessible in Graphical EXPLAIN View.
• Fixed a schema diff issue where generated script adds unwanted line endings for Functions/Procedures/Trigger Functions.