Scheduling data input from tab delimited file via php

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: Raw Message | Whole Thread | 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

Responses

Browse pgsql-novice by date

  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