Simple, free PG GUI/query tool wanted

Started by Gauthier, Daveover 15 years ago6 messagesgeneral
Jump to latest
#1Gauthier, Dave
dave.gauthier@intel.com

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.

#2Elford,Andrew [Ontario]
Andrew.Elford@ec.gc.ca
In reply to: Gauthier, Dave (#1)
Re: Simple, free PG GUI/query tool wanted

http://www.pgadmin.org/download/windows.php

________________________________

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.

#3Brent Wood
b.wood@niwa.co.nz
In reply to: Elford,Andrew [Ontario] (#2)
Re: Simple, free PG GUI/query tool wanted

Hi,

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

Brent Wood
DBA/GIS consultant
NIWA, Wellington
New Zealand

"Elford,Andrew [Ontario]" 12/15/10 11:05 AM >>>

http://www.pgadmin.org/download/windows.php

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.

Please consider the environment before printing this email.

NIWA is the trading name of the National Institute of Water & Atmospheric Research Ltd.

#4Joshua D. Drake
jd@commandprompt.com
In reply to: Brent Wood (#3)
Re: Simple, free PG GUI/query tool wanted

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

#5Sandeep Srinivasa
sss@clearsenses.com
In reply to: Joshua D. Drake (#4)
Re: Simple, free PG GUI/query tool wanted

you could try SQLWorkbench (http://www.sql-workbench.net/)

#6mark_r
meshtalik@hotmail.com
In reply to: Gauthier, Dave (#1)
Re: Simple, free PG GUI/query tool wanted

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.

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general