Re: client that supports editing views

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(at)gmx(dot)net> wrote:

> 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
>
>
>
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

--
"Quality comes from focus and clarity of purpose" -- Mark Shuttleworth