Create table in postgreSQL with comments being included in tDbOutput schema

[mauerwegrunner]

Hello,

I often use the functionality "drop table if exists and create" which is very useful. Now I've tried to include comments to columns in the schema, which should be part of the new created output table. So I've tested it by adding some comment text in schema column "comment"

.

I've tried double double quotation, single quotation and no quotation. However, the comments do not appear in the created table's DDL:

The default value appears. What is wrong? I am using TOS 7.3.1, target tables are in a postgreSQL 12.7

Thanks in advance, Matthias

[Anonymous]

Hello,

Are you able to apply the Talend schema comments in DB columns comment with tCreateTable component?

Best regards

Sabrina

[mauerwegrunner]

Hello Sabrina,

I tried, but there is no comment as well:

[Anonymous]

Hello,

It seems to be a new feature as there exists a jira issue: https://jira.talendforge.org/browse/TDI-20519

Best regards

Sabrina

[mauerwegrunner]

Hello Sabrina,

thanks for the answer. Then I will use an alter table script and add comments for the time being.

Best regards,

Matthias