topic Re: tCreateTable for PostgreSQL 10 - GENERATED ALWAYS AS IDENTITY in Talend Studio

tCreateTable for PostgreSQL 10 - GENERATED ALWAYS AS IDENTITY

DODGEEK — Sat, 16 Nov 2024 01:48:17 GMT

Hi,

I am trying to find the option in tCreateTable to support the GENERATED ALWAYS AS IDENTITY option in PostgreSQL 10. I am not able to create an auto increment field using tCreateTable at the moment.

https://www.postgresqltutorial.com/postgresql-identity-column/#:~:text=The%20GENERATED%20ALWAYS%20instructs%20PostgreSQL,value%20for%20the%20identity%20column.

Re: tCreateTable for PostgreSQL 10 - GENERATED ALWAYS AS IDENTITY

Anonymous — Tue, 28 Jul 2020 08:46:59 GMT

It is an universal schema using tCreateTable, does not has extra option for specifying GENERATED ALWAYS AS IDENTITY. Use tPostgreSQLRow to execute the SQL?

Regards

Shong

Re: tCreateTable for PostgreSQL 10 - GENERATED ALWAYS AS IDENTITY

DODGEEK — Thu, 20 Aug 2020 13:10:53 GMT

Thanks. This was helpful to understand. Will write custom SQL to work around this.