| From: | Dimitri Fontaine <dfontaine(at)hi-media(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: free scheduled import utility |
| Date: | 2007-07-10 12:43:08 |
| Message-ID: | 200707101443.10957.dfontaine@hi-media.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support pgsql-general |
Le mardi 10 juillet 2007, Zlatko Matic a écrit :
> Is there any free program/utility for batch imports from .csv files, that
> can be easily scheduled for daily inserts of data to PostgreSQL tables?
COPY itself would do the job, but you can also use pgloader:
http://pgfoundry.org/projects/pgloader
It has many options, and is able to load data in the presence of errors,
logging them (both error.log and reject.log).
Hope this helps, regard,
--
dim
| From | Date | Subject | |
|---|---|---|---|
| Next Message | A. Kretschmer | 2007-07-10 12:48:52 | Re: free scheduled import utility |
| Previous Message | Reid Thompson | 2007-07-10 12:38:28 | Re: free scheduled import utility |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | A. Kretschmer | 2007-07-10 12:48:52 | Re: free scheduled import utility |
| Previous Message | Reid Thompson | 2007-07-10 12:38:28 | Re: free scheduled import utility |