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.
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
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
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?
