views:

2238

answers:

6

Hi guys, 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

+2  A: 

Doesn't TOAD exist for several plattforms?

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

http://www.pgadmin.org/

jishi
+2  A: 

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?

Will Green
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.
Edited my answer to add a few other options, based on edit to original question.
Will Green
Ended up with EMS SQL Manager - thanks for the nudge.
+1  A: 

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

Nic Gibson
A: 

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

DanielHonig
A: 

Yes, RazorSQL. It supports PostgreSQL, Oracle, MS SQL Server, MySQL, SQLite, Sybase, etc. in one tool. No need to have a tool for each database.

Deb Timmons