One Star

[resolved] export datas from Postgresql database to .csv file

Hi
I'm trying to export datas from a postgresql database in csv file.
first i created a metadata about my database, I checked the connection. I created a schema to get access to table . everything is Ok
second i drag and drop the table from the metadata in the job, the wizzard propose to create a TELTpostgresinput component. I create a tmap , a tFileoutputdelimeted.
when i try to link the TELTpostgresinput to tmap it fails!
I cannot link the TELTpostgresinput to another component except a teltpostgresmap whitch cannot be linked to the tFileoutputdelimeted.
what is the correct way?
1 ACCEPTED SOLUTION

Accepted Solutions
One Star

Re: [resolved] export datas from Postgresql database to .csv file

thanks
I didn't find the rigth component because I forgot to enable Postgres in the palette project options.
I must be more concentrated!
regards
2 REPLIES
One Star

Re: [resolved] export datas from Postgresql database to .csv file

Hi
Welcome to Talend Community!
Try to use tPostgreSqlInput component here. Then you will get the result.
The wizzard is to help you choose the components about postgresql. It's just a list without order.
Regards,
Pedro
One Star

Re: [resolved] export datas from Postgresql database to .csv file

thanks
I didn't find the rigth component because I forgot to enable Postgres in the palette project options.
I must be more concentrated!
regards