topic Adding column to connected database schema in Talend Studio

Adding column to connected database schema

Anonymous — Tue, 28 Mar 2017 10:23:08 GMT

Hi all,

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

Please help

Re: Adding column to connected database schema

Anonymous — Tue, 28 Mar 2017 12:42:20 GMT

Hi,
Here is a TalendHelpCenter:tPostgresqlRow which executes the SQL query stated onto the specified database.You can add your Alter statement in this component.
Best regards
Sabrina

Re: Adding column to connected database schema

Anonymous — Wed, 29 Mar 2017 01:45:29 GMT

@xdshi hello. I have read through the guide but I am still not sure how to add the alter table into the query.
I would like to know what is wrong with what I have done.

Re: Adding column to connected database schema

Anonymous — Wed, 29 Mar 2017 09:53:28 GMT

Hi,
Screenshots of your component setting will be helpful for us to address your issue.
Best regards
Sabrina