| From: | Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com> |
|---|---|
| To: | "Jim C(dot) Nasby" <jimn(at)enterprisedb(dot)com> |
| Subject: | Re: [HACKERS] Is there any utility to update the table whenever text |
| Date: | 2006-09-17 00:51:52 |
| Message-ID: | 450C9C28.6030308@cheapcomplexdevices.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron Johnson | 2006-09-17 01:19:03 | Re: PostgreSQL slammed by PHP creator |
| Previous Message | Jim C. Nasby | 2006-09-16 21:02:35 | Re: [HACKERS] Is there any utility to update the table whenever text file gets changed? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2006-09-17 00:57:22 | Re: minor feature request: Secure defaults during function creation |
| Previous Message | Tom Lane | 2006-09-17 00:36:24 | Re: Reducing data type space usage |