How do I alter column in talend? I am using postgresql. I have dragged and drop the schema "table1" at the job design. The table1 is currently connected to a tMap.
From the schema of table1, I can see the default query: "Select .... From ....
I tried adding this line at the bottom so that I can add a ID column to the schema:
ALTER TABLE table1 ADD id integer
But I got an error message:
Detail Message: id cannot be resolved to a type
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables