Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Adding column to connected database schema

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

Labels (2)
3 Replies
Anonymous
Not applicable
Author

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
Anonymous
Not applicable
Author

@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.
Anonymous
Not applicable
Author

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