Re: automating csv import - Mailing list pgsql-general

From John Sidney-Woollett
Subject Re: automating csv import
Date
Msg-id 42135798.1040008@wardbrook.com
Whole thread Raw
In response to automating csv import  ("walker1145" <walker1145@qwest.net>)
List pgsql-general
Have you tried creating a script to do the import operation, and then
scheduling it to run periodically using cron (on unix) or at (on windows)?

Seems like that is all you need to do...

John Sidney-Woollett

walker1145 wrote:

> I get a dump of some data in a CSV file and am able to import it
> manually using psql and \COPY without a problem. However I now need to
> automate this as  it will need to be done every 2 hours 24/7. I've tried
> looking through the archives and nothing seems to touch upon this
> completely and the documentation doesn't mention this or if it does it
> seems to be some what obscure (at least to me). Does anyone have any
> suggestions?
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Lost rows/data corruption?
Next
From: David Fetter
Date:
Subject: Re: insert data from an microsoft excel