2

I'm looking for a nice visual explorer for PostgreSQL.

I found DataGrip by JetBrains. The issue is the price is high, at least for me.

I would like to have another explorer, which is comfortable, visually speaking and with a lower price. The explorer has to be for Windows (7 and onward). But it has to be an IDE too, because I'm developing SQL queries.

  • 1
    What features do you need? Is a simple database browser enough? The "D" in "IDE" means "Development", what kind of development do you need the tool to allow you to do? – Nicolas Raoul Nov 15 '16 at 7:22
  • Hi @NicolasRaoul, I need the same thing as I have with SqlServer Management Studio but for postgres (e.g having a tree with the referencing of the objects in the db, be able to write queries that will put the correct syntax and the correct object names). – Andy K Nov 15 '16 at 7:44
  • @AndyK Please edit your Question with further information rather than post as comments. – Basil Bourque Nov 20 '16 at 7:05
3

I use pgAdmin for this.

It meets your requirements as far as I can tell:

  • Works with Windows 7 and onwards
  • Has a visual tree tree with the referencing of the objects in the db
  • Able to write queries
  • Hi @ryan-weaver nice! I need to have a look. Thanks. – Andy K Nov 15 '16 at 18:21
  • Distributions of Postgres commonly bundle pgAdmin. So you may already have it. Beware that the many-years-old well-worn edition of pgAdmin (QT-based C app) is being replaced with an all-new dual-purpose web app/desktop app edition, with all-new code base. – Basil Bourque Nov 20 '16 at 7:08
1

pgAdmin is the best option because it is built for PostgreSQL only.

I am using pgAdmin and Database .NET, Database .NET is my favorite since it has many good features which pgAdmin doesn't. It is very lightweight (free and commercial versions are available) and portable.You can connect many databases with this.

enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.