| From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
|---|---|
| To: | Dhanaraj M <Dhanaraj(dot)M(at)Sun(dot)COM> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Is there any utility to update the table whenever text file gets changed? |
| Date: | 2006-09-22 17:24:19 |
| Message-ID: | 20060922172419.GA3193@wolff.to |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
On Thu, Sep 14, 2006 at 03:41:06 -0700,
Dhanaraj M <Dhanaraj(dot)M(at)Sun(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Davis | 2006-09-22 17:34:56 | Re: Replication and PITR |
| Previous Message | Jim C. Nasby | 2006-09-22 17:03:03 | Re: postgresql rising |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim C. Nasby | 2006-09-22 17:29:06 | Re: advisory locks and permissions |
| Previous Message | Merlin Moncure | 2006-09-22 17:21:57 | Re: advisory locks and permissions |