| From: | "Dylan Fogarty-MacDonald" <dylan(dot)fm(at)gmail(dot)com> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Scheduling data input from tab delimited file via php |
| Date: | 2006-08-07 03:59:38 |
| Message-ID: | 37299ac20608062059q29f319d2tf57dec35b37dcdea@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Hi,
I have a client comprising of a group of car dealerships. Thier
accounting software uploads via ftp a tab delimited file of their
updated stock whenever the stock is updated.
What I need to do is execute a php scipt that imports data from the
file into the database at a regular interval, ie. every hour.
Does postgres have an ability handle this in a different way, maybe by
removing the need to use php at all?
Can postgres be scheduled for actions like this? Or will I need to
have the php file schedule the action itself?
Basically, I need to know if postgres can be scheduled, and if it can
open/execute files on a server.
Thankyou,
I hope this was written in an understandable way...
-Dylan
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2006-08-07 04:24:29 | Re: Scheduling data input from tab delimited file via php |
| Previous Message | Tom Lane | 2006-08-07 03:44:55 | Re: Cannot connect though socket |