|
<< Click to Display Table of Contents >> Navigation: Supported database systems > PostgreSQL > PostgreSQL tools |
From the pgAdmin website:
"pgAdmin is the most popular and feature rich Open Source administration and development platform for PostgreSQL, the most advanced Open Source database in the world. pgAdmin may be used on Linux, Unix, macOS and Windows to manage PostgreSQL and EDB Advanced Server 11 and above."
"pgAdmin is a management tool for PostgreSQL and derivative relational databases such as EnterpriseDB's EDB Advanced Server. It may be run either as a web or desktop application. For more information on the features offered, please see the Features and Screenshots pages."
pdAdmin 4 is free and open source. The latest version is pgAdmin 4 version 9.
dbForge is not free software but it is extremely economical ($99.95 US for a one-year subscription) considering hours of time that it can save you.
dbForge is invaluable when importing legacy data contained in poorly formatted CSV or Excel files. It can also pull live data from sources like Microsoft Access and Microsoft SQL Server. For example, dbForge can pull data directly from and existing Truck Scale Ticketing Software like Interact/Transact or WinVRS databases without having to go through the headache of exporting, formatting and importing CSV files.
How to Export or Import a PostgreSQL Database Using CSV, Excel, or Dump
dbForge also contains reporting and visualization tools.
From the Devart website:
"dbForge Studio for PostgreSQL is a GUI client and universal tool for PostgreSQL database development and management. The tool is cross-platform and is compatible with Windows, Linux, and macOS. This PostgreSQL IDE allows users to create, develop, and execute queries, edit and adjust the code to their requirements in a convenient and user-friendly interface. It also provides functionality for PostgreSQL data reporting, data editing, data import and export, building pivot tables, and master-detail relations."
From the HeidiSQL website:
"HeidiSQL is free software for people who work with databases, and aims to be intuitive to use. "Heidi" lets you connect to a variety of databases, like MariaDB, MySQL, Microsoft SQL, PostgreSQL, SQLite, Interbase and Firebird. Once you are connected, you can edit data and structures in these databases."
If you find it useful, please make a financial contribution towards the development of HeidiSQL.