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:
- 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.
- 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.
|Operating systems||Windows 7, Linux, BSD, macOS, Solaris, UNIX, Windows Server 2008, Windows Server 2012, Windows 8, Windows 10, Windows Server 2016, Windows Server 2019, Windows 11|
|License type||Conditions (GNU/BSD/etc.)|