Thread: Is there any utility to update the table whenever text file gets changed?

Is there any utility in postgresql which can do the following?

The utility must update the table whenever there is any change in the 
text file.
COPY command helps to do that, though this is not straight forward.
Can it be automated?

Thanks
Dhanaraj

On Thu, Sep 14, 2006 at 03:41:06 -0700, Dhanaraj M <Dhanaraj.M@Sun.COM> wrote:
> Is there any utility in postgresql which can do the following?
> 
> The utility must update the table whenever there is any change in the 
> text file.
> COPY command helps to do that, though this is not straight forward.
> Can it be automated?

You would either need to have the application which changes the text file
do soemthing or have another program watching the text file to see when
it changes and then take action. You probably don't want to use COPY as
that essentially does inserts, not updates.