In the scope of a small community project we were compelled to create a database in order to manage our events, the participating members, their contact details and so on. I've created a PostgreSQL DB with different tables containing columns and their relationships. Now certain members of the project should be able to add, view and update entries in specific tables. I'm looking for a GUI front end tool that will enable users with no database experience to do these tasks. We specifically need following features:
- a form layout to add and modify entries
- a table layout for viewing an entire table
An additional plus would be, if the software would recognise the foreign key constraints and provide drop down menus with the possible options.
Can anybody recommend software? Is there anything out there tailored to PostgreSQL? A webbased application would also be an option.