Re: Data Entry Tool for PostgreSQL - Mailing list pgsql-general

From Brent Wood
Subject Re: Data Entry Tool for PostgreSQL
Date
Msg-id 20050926124556.E86030@storm-user.niwa.co.nz
Whole thread Raw
In response to Data Entry Tool for PostgreSQL  ("Ian Overton" <ioverton@mappingandbeyond.com>)
Responses Re: Data Entry Tool for PostgreSQL
Re: Data Entry Tool for PostgreSQL
List 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

pgsql-general by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: What is an 'unused item pointer'
Next
From: "Cristian Prieto"
Date:
Subject: Index use in BETWEEN statement...