GUI to edit a table's content

Gauthier, Dave wrote on 27.08.2009 23:17:

Are there any GUI apps out there that can be used to edit (insert,
update, delete) table data? SOmething with enough smarts to sniff out
constraint violations and report accordingly. Also, ability to eval
constraints at commit time inside a transaction (option to rollback of
course).

Check out this list:

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

Hmmmm.. I didn't see anything in http://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools that stood out in terms of being able to edit table content in a GUI. Maybe MSACCESS, but my PG DB is served on Linux.

I have googled around for something like this and was amazed at how little there is out there, at least in freeware. Perhaps this is an opportunity for me to develop something, but re-inventing the wheel here where I work is frowned upon. So I'm still looking.

-----Original Message-----
From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Thomas Kellerer
Sent: Thursday, August 27, 2009 5:32 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] GUI to edit a table's content

Gauthier, Dave wrote on 27.08.2009 23:17:

Are there any GUI apps out there that can be used to edit (insert,
update, delete) table data? SOmething with enough smarts to sniff out
constraint violations and report accordingly. Also, ability to eval
constraints at commit time inside a transaction (option to rollback of
course).

Check out this list:

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

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

Gauthier, Dave, 28.08.2009 16:08:

Hmmmm.. I didn't see anything in
http://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools
that stood out in terms of being able to edit table content in a GUI.
Maybe MSACCESS, but my PG DB is served on Linux.

The question is: what do you mean with "edit in a GUI". e.g. with Squirrel or SQL Workbench/J you can run "SELECT * FROM my_table" and edit the contents of the result directly.

Are you talking about something different?

Thomas