- PgAdmin is one of the best free PostgreSQL editor software for Windows. The software is not only a good editor, but using it you can do almost any task in a PostgreSQL database. The software is not only a good editor, but using it you can do almost any task in a PostgreSQL database.
- Also, it has a nice import/export tool. If you receive a file which contains data you need to import and work on it, you can parse it (from CSV, XLS, SQL file or other types) and populate an existing table and even create a new table to suit the new data.
There is no 'best'. But I do like pgAdmin, works on any OS, not just OS X, and is for free. You could also use OpenOffice Base to connect to your database, using JDBC. Best Video Software for the Mac How To Run MacOS High Sierra or Another OS on Your Mac Best Graphic Design Software the Mac. (PostgreSQL GUI tool) for Mac. In Bigger SQL and PGnJ you can.
Active1 year, 7 months ago
I'm interested to find the best desktop database query tool for PostgreSQL. Some options are PGadmin, RazorSQL. I'm interested to know which are the best ones.
Richard PriceRichard Price
closed as off-topic by meagar♦Feb 4 '18 at 14:29
This question appears to be off-topic. The users who voted to close gave this specific reason:
- 'Questions asking us to recommend or find a book, tool, software library, tutorial or other off-site resource are off-topic for Stack Overflow as they tend to attract opinionated answers and spam. Instead, describe the problem and what has been done so far to solve it.' – meagar
6 Answers
After evaluating a bunch of GUI-based options for OSX I settled on Navicat for Postgresql because to me, it has a more natural UI than pgAdmin (at least for OSX).
I find pgAdmin has a better query analysis tool though so I've got it installed as well.
Max RBMax RB
For some definition of 'best' I humbly offer up
PhrogzPhrogzpsql
; it is fast and easy, free, and already installed. :)Itool For Mac
233k8787 gold badges559559 silver badges642642 bronze badges
For query only I use DbVisualiser. It is a cross platform Java application.
BillThorBillThor5,83711 gold badge2020 silver badges1717 bronze badges
There is no 'best'. But I do like pgAdmin, works on any OS, not just OS X, and is for free. You could also use OpenOffice Base to connect to your database, using JDBC.
Frank HeikensFrank Heikens78.6k2222 gold badges114114 silver badges119119 bronze badges
We Use PGAdmin. Not had any issues with it other than the following (unsatisfactory answered - by myself) question I posted a while back.
Community♦
Mr ShoubsMr Shoubs6,8631414 gold badges5757 silver badges9696 bronze badges
You might want to try SQL Workbench/J (Java based): http://www.sql-workbench.net
a_horse_with_no_namea_horse_with_no_name
332k5454 gold badges515515 silver badges609609 bronze badges