Re: [HACKERS] Is there any utility to update the table whenever text - Mailing list pgsql-general

From Ron Mayer
Subject Re: [HACKERS] Is there any utility to update the table whenever text
Date
Msg-id 450C9C28.6030308@cheapcomplexdevices.com
Whole thread Raw
In response to Re: [HACKERS] Is there any utility to update the table whenever text file gets changed?  ("Jim C. Nasby" <jimn@enterprisedb.com>)
List pgsql-general
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.

pgsql-general by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: [HACKERS] Is there any utility to update the table whenever text file gets changed?
Next
From: Ron Johnson
Date:
Subject: Re: PostgreSQL slammed by PHP creator