Search Postgresql Archives

Re: client that supports editing views

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux