topic Re: Create table in postgreSQL with comments being included in tDbOutput schema in Talend Studio

Create table in postgreSQL with comments being included in tDbOutput schema

mauerwegrunner — Fri, 04 Jun 2021 06:46:58 GMT

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

Re: Create table in postgreSQL with comments being included in tDbOutput schema

Anonymous — Fri, 04 Jun 2021 09:10:36 GMT

Hello,

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

Best regards

Sabrina

Re: Create table in postgreSQL with comments being included in tDbOutput schema

mauerwegrunner — Fri, 04 Jun 2021 11:05:25 GMT

Hello Sabrina,

I tried, but there is no comment as well:

Re: Create table in postgreSQL with comments being included in tDbOutput schema

Anonymous — Mon, 07 Jun 2021 05:26:26 GMT

Hello,

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

Best regards

Sabrina

Re: Create table in postgreSQL with comments being included in tDbOutput schema

mauerwegrunner — Mon, 07 Jun 2021 06:01:27 GMT

Hello Sabrina,

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

Best regards,

Matthias