Hi, 2013-12-09 Thomas Kellerer <spam_eater@xxxxxxx>: > 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@xxxxxxx>: > 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
