Good Front end for PostgreSQL on Windows or Mac

Posted by anjanb on Stack Overflow See other posts from Stack Overflow or by anjanb
Published on 2010-03-28T10:54:58Z Indexed on 2010/03/28 11:03 UTC
Read the original article Hit count: 302

Filed under:

postgresql

|

frontend

|

Windows

|

free

|

oss

I'm considering using postgreSQL 8.4x db on windows/Mac for development and linux for production. wondering what front-end tools are out there that are comparable to Toad (for Oracle) ?

PostgreSQL comes with PgAdminIII. It's OK but I feel there might be something better than that. I prefer free or open source but if something is NOT too expensive(we are a NON-PROFIT), would not mind evaluating.

minimal tools that I want
1) connection manager
2) Nice SQL Editor
3) Explain Plan
4) help with SQL embedding into various languages.
5) E-R diagrams would be good but this would not be a killer feature for me.

Anything work for you guys ?

Will be using java 6 to build the application(s) if that is relevant at all.

Thank you,

© Stack Overflow or respective owner

Related posts about postgresql

Postgresql fails to start on Ubuntu 10.04.4 LTS

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
I installed postgresql 9.2 from add-apt-repository ppa:pitti/postgresql using apt-get install postgresql-9.2 At the end of the install and every time I try to launch postgresql by using the following command /etc/init.d/postgresql start or service postgresql start I get this error: Error:… >>> More
can't install psycopg2 in my env on mac os x lion

as seen on Server Fault - Search for 'Server Fault'
I tried install psycopg2 via pip in my virtual env, but got this error: ld: library not found for -lpq (full log here: http://pastebin.com/XdmGyJ4u ) I tried install postgres 9.1 from .dmg and via port, (gksks)iMac-Alexander:~ lorddaedra$ locate libpq /Developer/SDKs/MacOSX10.7.sdk/usr/include/libpq /Developer/SDKs/MacOSX10… >>> More
Postgresql has broken apt-get on Ubuntu

as seen on Super User - Search for 'Super User'
On ubuntu 12.04, whenever I try to install a package using apt-get I'm greeted by: The following packages have unmet dependencies: postgresql-9.1 : Depends: postgresql-client-9.1 but it is not going to be instal led E: Unmet dependencies. Try 'apt-get -f install' with no packages (or specify a so lution)… >>> More
Installing PostgreSQL on FreeBSD (with ports)

as seen on Server Fault - Search for 'Server Fault'
Hey everyone, I am trying to install (using ports) PostgreSQL on a virtual server, running FreeBSD. My one question is this: Which of the following should I install? postgresql-contrib postgresql-docs postgresql-jdbc postgresql-libpgeasy postgresql-libpq++ postgresql-libpqxx postgresql-odbc … >>> More
Strange permission errors in new PostgreSQL installation

as seen on Server Fault - Search for 'Server Fault'
A freshly installed PostgreSQL (with configuration overwritten) won't start: $ sudo service postgresql start * Starting PostgreSQL 9.1 database server * Error: could not read /etc/postgresql/9.1/main/postgresql.conf: Permission denied Looks like it should be able to read it though: $ ls -l postgresql… >>> More

Related posts about frontend

Does any SQL frontend display subdatasheets like Access?

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm looking for an SQL client app that can display subdatasheets like the following: Do you know of any? >>> More
What is a good git server frontend for self hosted git repositories

as seen on Stack Overflow - Search for 'Stack Overflow'
I am planning on deploying git for a project I am currently working on and was wondering if there are any free softwares that provide an easy to use web view of the git repository. I am primarily interested in using the front end to track changes, see diff information etc. There is a list of such… >>> More
Any rsync frontend that supports SSH for Linux ?

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, any rsync frontend that works with SSH for Linux ? I tried Unison, but i think it needs the server has installed also Unison. Regards Javi >>> More
Which MySQL Frontend shows foreign rows?

as seen on Stack Overflow - Search for 'Stack Overflow'
I once came across a MySQL Frontend app that displayed foreign linked rows within the parent row, if for instance the Events table has a foreign key to the Students table: Student ID Name DOB -- ---- --------- [+] 22 Bob 25-1-1984 [-] 21 Jane 25-1-1982 Event ID… >>> More
joomla: editing the mvc package for joomla component development

as seen on Stack Overflow - Search for 'Stack Overflow'
hi! i m new to joomla component development i hv just downloaded bunch of files from some jooomla mvc generater website.which llok like smthng like this hello.xml - frontend/index.html - frontend/hello.php - frontend/controller.php - frontend/models/index.html - frontend/models/hello… >>> More