Re: free scheduled import utility - Mailing list pgsql-general

From Dimitri Fontaine
Subject Re: free scheduled import utility
Date
Msg-id 200707101443.10957.dfontaine@hi-media.com
Whole thread Raw
In response to free scheduled import utility  ("Zlatko Matic" <zlatko.matic1@sb.t-com.hr>)
List 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

Attachment

pgsql-general by date:

Previous
From: Reid Thompson
Date:
Subject: Re: free scheduled import utility
Next
From: "A. Kretschmer"
Date:
Subject: Re: free scheduled import utility