Re: Data Entry Tool for PostgreSQL

From: Brent Wood <b(dot)wood(at)niwa(dot)co(dot)nz>
To: Ian Overton <ioverton(at)mappingandbeyond(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Data Entry Tool for PostgreSQL
Date: 2005-09-26 00:49:40
Message-ID: 20050926124556.E86030@storm-user.niwa.co.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, 23 Sep 2005, Ian Overton wrote:

> Hello,
>
> We have a web application using PHP, Linux and PostgreSQL. We need a
> simple data entry tool to allow non-IT people to edit data in our database
> through a web-browser. Are there any free or commercial data management
> tools out there, not database management tools like pgAdmin.

I would have thought a php appliction would be able to this fairly
easily. My data entry scripts insert the new records with just a primary
key, then iterate through the various fields using an update sql for each
one which is not null.

This sort of approach coul easily be used to populate an on-screen table
using php, then update any changed fields as required.

Cheers,

Brent Wood

k

Responses

Browse pgsql-general by date

  From Date Subject
Next Message CSN 2005-09-26 01:50:21 Function keys cause psql to segfault
Previous Message Bruce Momjian 2005-09-26 00:09:18 Re: PQtrace doesn't work