Postgres Pro
Downloads
Home   >   mailing lists

Thread: GUI to edit a table's content

GUI to edit a table's content

From
"Gauthier, Dave"
Date:

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).

 

Thanks for any pointers.

Re: GUI to edit a table's content

From
Thomas Kellerer
Date:
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

Re: GUI to edit a table's content

From
"Gauthier, Dave"
Date:
Hmmmm.. I didn't see anything in http://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools that stood out
interms 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.
Perhapsthis 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

Re: GUI to edit a table's content

From
Thomas Kellerer
Date:
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 *
FROMmy_table" and edit the contents of the result directly.  

Are you talking about something different?

Thomas