Thread: Simple, free PG GUI/query tool wanted
Hi:
I'm trying to find a simple, easy-to-use, open (free), Windows based query tool for PG. This would be something for the novice end user, a means to build a query, execute it, export results out to a csv or Excel or something like that. Tools with metadata editors are actually undesirable (they don't need it, will just serve to get the confussed, could give them info that would get them into trouble). GOing through ODBC is undesirable, but understandable if there are no other options.
I've looked through the Community_Guide_to_PostgreSQL_GUI_Tools but found nothing that foots that bill (but I may have missed something). I'm looking for something similar to MySQL's "Query Browser" or SQLyog.
From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Gauthier, Dave
Sent: December 14, 2010 1:38 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Simple, free PG GUI/query tool wanted
Hi:
I'm trying to find a simple, easy-to-use, open (free), Windows based query tool for PG. This would be something for the novice end user, a means to build a query, execute it, export results out to a csv or Excel or something like that. Tools with metadata editors are actually undesirable (they don't need it, will just serve to get the confussed, could give them info that would get them into trouble). GOing through ODBC is undesirable, but understandable if there are no other options.
I've looked through the Community_Guide_to_PostgreSQL_GUI_Tools but found nothing that foots that bill (but I may have missed something). I'm looking for something similar to MySQL's "Query Browser" or SQLyog.
pgadmin is still an admin tool, NOT a simple user query tool. I'd suggest PG Access as worth a look, but unfortunately it is no longer supported, and I have never tried it with a recent version of Postgres.
Brent Wood
DBA/GIS consultant
NIWA, Wellington
New Zealand
>>> "Elford,Andrew [Ontario]" 12/15/10 11:05 AM >>>
From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Gauthier, Dave
Sent: December 14, 2010 1:38 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Simple, free PG GUI/query tool wanted
Hi:
I'm trying to find a simple, easy-to-use, open (free), Windows based query tool for PG. This would be something for the novice end user, a means to build a query, execute it, export results out to a csv or Excel or something like that. Tools with metadata editors are actually undesirable (they don't need it, will just serve to get the confussed, could give them info that would get them into trouble). GOing through ODBC is undesirable, but understandable if there are no other options.
I've looked through the Community_Guide_to_PostgreSQL_GUI_Tools but found nothing that foots that bill (but I may have missed something). I'm looking for something similar to MySQL's "Query Browser" or SQLyog.
NIWA is the trading name of the National Institute of Water & Atmospheric Research Ltd.
Gnome and KDE and OpenOffice all have free simple query tools On Wed, 2010-12-15 at 11:12 +1300, Brent Wood wrote: -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579 Consulting, Training, Support, Custom Development, Engineering http://twitter.com/cmdpromptinc | http://identi.ca/commandprompt
You can use free tool - Valentina Studio http://www.valentina-db.com/en/valentina-studio-overview 14 Feb 2013 in the 5.0 version added support of PostgreSQL, as well as mySQL/mariaDB, SQLite. It is FREE. Works on Mac, Win and Linux. Includes not only db management but powerfull reports that work again on 3 OS. -- View this message in context: http://postgresql.1045698.n5.nabble.com/Simple-free-PG-GUI-query-tool-wanted-tp3305055p5754182.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.