Thread: GUI client

Andre,
My organization chose to develop a front-end in Microsoft Access, using
forms, for general users to update PostgreSQL tables. The connections
between the Access forms and PostgreSQL are made using the generic ODBC
driver from the PostgreSQL site.

If open source software options are preferred, I would assume Base,
from OpenOffice, can be used to do the same thing as it is intended to
be an Access alternative. That said, we have not tried to do the same
thing with Base so I cannot say for sure.

- Mike





>>> On 8/9/2016 at 1:05 PM, ALT SHN <i.geografica@alt-shn.org> wrote:
> Dear all,
>
> I am looking for a GUI client for our PostgreSQL database. This
database
> was designed to support the inventory of paleontological collections,
and
> is full of fk, codelists, enumerations and triggers to ensure data
> consistency.
>
> Now the problem is to have our staff entering data as they go through
the
> inventory effort.
>
> Therefore I am looking for a nice GUI client that spares the users
from
> learning SQL and that provides a nice interface for entering data.
This
> means for example having a system that allows to pick values from an
> enumeration or from the table whose PK is acting as FK in the table
> currently being edited.
>
> Any suggestions?
>
> Kind Regards,
>
> Andre
>
>
>
> --
> ---------------------------------------------------------------
>
>
> *Sociedade de História Natural*
> Departamento de Informação Geográfica
> Polígono Industrial do Alto do Amial
> Pav.H02 e H06
>
> i.geografica@alt-shn.org <laboratorio@alt-shn.org>
> www.shn.pt
> www.alt-shn.blogspot.com
> Facebook
<https://www.facebook.com/SociedadeDeHistoriaNatural?ref=hl>
>
> TLM: 964138188

Plus one for libreoffice base. It takes some tinkering but I managed to build a small psql 9.5 Interface with many to many relations and lookup tables. I did find more help and documentation with OpenOffice but stuck with base because anything OpenOffice develops can be ported to base but not the other way around, has to do with the licensing.
Good luck
Tyler

Sent from my Bell Sony device over Canada’s largest network.

---- ALT SHN wrote ----

SQLeo can help,
It is a java front end.



--
Sent from: http://www.postgresql-archive.org/PostgreSQL-novice-f2132464.html


-- 
Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice