cool, SQL Workbench/J: does the job.
It's too bad that it doesn't list the lables/views, so that you can't just open them with a click (i use select * from table to get the data), but it works well.
thanks Thomas.On Mon, Dec 9, 2013 at 11:51 PM, Thomas Kellerer <spam_eater@xxxxxxx> wrote:
Willy-Bas Loos wrote on 09.12.2013 21:44:If pgAdmin is acceptable, you might want to try SQL Workbench/J: http://www.sql-workbench.net
But the option to save the record is disabled, the other 2 buttons do not enable me to save the record.
Anyway, i don't care much for MS Access, any client will do (that is, if it costs money,
it would be nice if most users own it already or it isn't very expensive)
I've tried:
* pgAdmin
* MS Access 2010 over ODBC
* LibreOffice.org with the SDBC driver.
Does anyone know of a client that is either smart enough to understand about rules on views,
or transparent enough to let the server handle everything?
It will allow to run inserts on anything that you can select from and it will prompt the user for the PK columns in case none could be identified in the database (such as when updating the result of a select based on a view or retrieving data from a table without a PK). The selection of the PK columns can be saved (locally) to avoid further prompting
Disclosure: I am the author of that tool.
Regards
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--
"Quality comes from focus and clarity of purpose" -- Mark Shuttleworth
