On Thu, Sep 14, 2006 at 03:41:06 -0700, Dhanaraj M <[EMAIL PROTECTED]> 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. ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq