how to import files from talend to postgres database

One Star

how to import files from talend to postgres database

HI all,
I have a csv file which I want to import from the talend into postgresql database. is it possible?
If yes, please tell me the detail steps for this.

Thanks in advance.
Regards,
Manoj
Community Manager

Re: how to import files from talend to postgres database

Hello
It is a simple request, just using to tFileInputDelimited to read the csv file and write the records into postgresql with tPostgresqlOutput component. For example:
tFileInputDelimited--row1--tPostgresqlOutput
Please read the user documentation about their usage.
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: how to import files from talend to postgres database

HI Shong,
Thanks for reply.
I have a csv file which contains the column names from the table of the postgresql database.
e.g. Name, Contacts/Contact Name, Contacts/City, Contacts/Fax etc.
and data like Microsoft, Sam, NewYork, 012545522

But when I create a new job as told by you tFileInputDelimited--row1--tPostgresqlOutput.
I am getting error
ERROR: relation "public.metadata" does not existERROR: current transaction is aborted, commands ignored until end of transaction blockERROR: current transaction is aborted, commands ignored until end of transaction blockERROR: current transaction is aborted, commands ignored until end of transaction block
where I am going wrong?
What is the solution for this?
Ragards,
Manoj
One Star

Re: how to import files from talend to postgres database

Hi,
I run the job successfully, but not getting the data into database.
I don job as : tFileInputDelimited--row1--tPostgresqlOutput
How to get data in database?