Re: Is there any utility to update the table whenever text file gets changed? - Mailing list pgsql-hackers

From Bruno Wolff III
Subject Re: Is there any utility to update the table whenever text file gets changed?
Date
Msg-id 20060922172419.GA3193@wolff.to
Whole thread Raw
In response to Is there any utility to update the table whenever text file gets changed?  (Dhanaraj M <Dhanaraj.M@Sun.COM>)
List pgsql-hackers
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.


pgsql-hackers by date:

Previous
From: David Fetter
Date:
Subject: Re: 8.3 Development Cycle
Next
From: "Jim C. Nasby"
Date:
Subject: Re: Getting a move on for 8.2 beta