Jim C. Nasby wrote:
> On Thu, Sep 14, 2006 at 03:41:06AM -0700, Dhanaraj M wrote:
>> The utility must update the table whenever there is any change in the
>> text file.
>> Can it be automated?
>
> There's nothing in the database that could do this directly.
I've seen examples where someone did this with DBI_link or some
derivative thereof - where when the table changes queries instantly
see the modified result..
DBI-Link documentation mentions that CSV and ps and Google
output can be used:
http://fetter.org/DBI-Link.pdf#search=%22dbi_link%20%22
so I'm guessing if he can write a DBI-like adapter for
the text file in question, this would work for him too.