Loading data

Hi everyone,

I'm using PostgresPlus 8.3.3. Here i'm having a problem while loading data.

The main problem is while loading using copy command if one row violates then its just throwing the error and comming out of loading instead of ignoring the bad data.

So for this i'm using pgloader 1.1

The second is i want to add extra column to get inserted which is not in csv along with loading.

Is there any way to load the data in to the table and is there any other option for loading data skipping the bad records.

Support for these two issues is really great helpful for me to move forward.

Thanks,
Venkat.

An ETL tool such as Talend would help with both of these issues.

As Jim says, Talend seems to be the solution for your problem. You can load data onto your database with the software. What i would suggest is you go look on the page for Talend open studio. I know there are plenty of tutorials and documentation you can read. You can also check the faq.