Re: client that supports editing views

Hi,

2013-12-09 Thomas Kellerer <spam_eater(at)gmx(dot)net>:
> Willy-Bas Loos wrote on 09.12.2013 21:44:
>> I've tried:
>> * pgAdmin
>> * MS Access 2010 over ODBC
>> * LibreOffice.org with the SDBC driver.
...
> If pgAdmin is acceptable, you might want to try SQL Workbench/J:
> http://www.sql-workbench.net

I'd like to revive that discussion and like to know:
Q1 => Can anybody recommend a >> desktop GUI tool (preferrably open
source) << for PG with customizable forms like Access or FileMaker?

I know this list [1] - but either it's an admin tool (scary for users)
or it's an abandoned project/product.

My current short list is either pgAdmin, SQL Workbench/J or Postgres
Forms (altough abandoned?).
My question here is:
Q2 => Does it make sense to write a plugin for pgAdmin (in C/C++) or
SQL Workbench/J (Java) or Forms (Tkl)??

-- Stefan

[1] http://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools
[2] http://pfm.projects.pgfoundry.org/

2013-12-09 Thomas Kellerer <spam_eater(at)gmx(dot)net>:
> 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