Login/Register
Is there anything as good as TOAD for Postgres (Windows)? [closed]
Asked Answered
Solved databasepostgresqltoad
R

7

27

I'm just looking for a management tool like TOAD for Postgres. Anyone used a good one?

Edit - I work mostly within the data itself and the database already has a mature model/design. I use the edit windows the most (well, in TOAD for Oracle anyway.)

As far as I know, Toad only exists naturally for: Oracle, MS SQL, DB2 and MySQL...

--JS

Rhizopod answered 15/4, 2009 at 17:25 Comment(0)
A
10

Not sure if TOAD for specific DB versions is any different than TOAD for Data Modeler, but it appears that TOAD Data Modeler supports PostgreSQL, along with a few others.

If you're looking for something like SQL Server Management Studio, but for Postgres, how about EMS SQL Manager or Lightning Admin?

Anthropogenesis answered 15/4, 2009 at 17:56 Comment(4)
Check out my edit :-) ... the design is already in place, I want to maintain views, data, create edits and so-forth, which, as far as I know, the data modeler doesn't really support directly? I could be wrong. – Rhizopod
Edited my answer to add a few other options, based on edit to original question. – Anthropogenesis
Ended up with EMS SQL Manager - thanks for the nudge. – Rhizopod
Quest doesn't have a tool. I have been asking them for one for EnterpriseDB and Postgres. They appear to have never heard of Postgres judging by the responses I have received. EMS SQL manager free edition is very good, Pro is even better. – Readability
J
11

Doesn't TOAD exist for several plattforms?

I'm using pgAdmin III which fills my needs so far.

http://www.pgadmin.org/

Janey answered 15/4, 2009 at 17:28 Comment(0)
A
10

Not sure if TOAD for specific DB versions is any different than TOAD for Data Modeler, but it appears that TOAD Data Modeler supports PostgreSQL, along with a few others.

If you're looking for something like SQL Server Management Studio, but for Postgres, how about EMS SQL Manager or Lightning Admin?

Anthropogenesis answered 15/4, 2009 at 17:56 Comment(4)
Check out my edit :-) ... the design is already in place, I want to maintain views, data, create edits and so-forth, which, as far as I know, the data modeler doesn't really support directly? I could be wrong. – Rhizopod
Edited my answer to add a few other options, based on edit to original question. – Anthropogenesis
Ended up with EMS SQL Manager - thanks for the nudge. – Rhizopod
Quest doesn't have a tool. I have been asking them for one for EnterpriseDB and Postgres. They appear to have never heard of Postgres judging by the responses I have received. EMS SQL manager free edition is very good, Pro is even better. – Readability
G
10

See the wiki: http://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools

Gloriagloriana answered 16/4, 2010 at 7:8 Comment(0)
G
3

TOra has some nice features and is supposed to be a lot like TOAD. Also, it is completely GPL so you can change the code yourself.

BTW: Toad is not OpenSource and is now only trialware (must re-install every 120 days). TOra is OpenSource so you don't have those issues.

Geostrophic answered 28/5, 2011 at 16:40 Comment(0)
N
1

I've used Navicat fairly extensively and successfully but only on a Mac. It has a Windows implementation that is, as far as I know, more feature rich than the Mac implementation.

I've had the odd data typing issue with it but, if you are not doing data modelling, that may not be an issue for you

Northeaster answered 15/4, 2009 at 19:41 Comment(0)
H
1

Because you do not need to edit the database design, I suggest SQL Workbench/J. It is Java application. You can use GUI mode (which I prefer to) and console mode (if you like psql-like command console). I use this app much more than pgAdmin III or pgAdmin 4 because it helps me to ease monitoring the database activity, deploying new version of DB app, etc.

Hackneyed answered 1/11, 2017 at 1:17 Comment(0)
K
0

Navicat for PostgreSQL is working really well for me natively. I set up phppgAdmin for the teams general use and it has been quite valuea ble

Kayseri answered 15/4, 2009 at 19:42 Comment(0)

© 2022 - 2024 — McMap. All rights reserved.