tCreateTable for PostgreSQL 10 - GENERATED ALWAYS AS IDENTITY

[DODGEEK]

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%20in...

[Anonymous]

Hi

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

[DODGEEK]

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