[resolved] Problem dbtype Postgresql

One Star

[resolved] Problem dbtype Postgresql

Hi, i use a postgresql db and i have create the schema in the links part of talend... i take a table of the schema and put in the job,create query and after i use guess schema..

I have a warning the dbtype not correct for this component..I open edit schema and i see all filed with type, the type of the type db is empty, how i can eliminate this warning?
Seventeen Stars

Re: [resolved] Problem dbtype Postgresql

Click in the dbType field for every column and choose the correct (mostly suggested) SQL data type.
Do not forget to set a pattern for all Date and Timestamp columns.
One Star

Re: [resolved] Problem dbtype Postgresql

Ok, i click on edit schema and choose for every field the dbtype and after close and is correct, but exist a method that generate automatically the dtype?

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Have you checked out Talend’s 2019 Summer release yet?

Find out about Talend's 2019 Summer release

Blog

Talend Summer 2019 – What’s New?

Talend continues to revolutionize how businesses leverage speed and manage scale

Watch Now

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog