Re: client that supports editing views

Willy-Bas Loos wrote on 09.12.2013 21:44:
> 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?

If pgAdmin is acceptable, you might want to try SQL Workbench/J: http://www.sql-workbench.net

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