'timestamp with time zone' for sql definition

[stanislavt]

Hi!
Will it possible to add one more datatype? I want to use 'timestamp with time zone' datatype for created and lastupdated columns. For my project I have used it like:
created: 'timestamp with time zone', lastupdated: 'timestamp with time zone'
but it calls a warning in console: [WARN] Using unknown data type TIMESTAMP WITH TIME ZONE.
I think the new datatype in the datatypes would be perfect!

--- Want to back this issue? **[Post a bounty on it!](https://www.bountysource.com/issues/37369760-timestamp-with-time-zone-for-sql-definition?utm_campaign=plugin&utm_content=tracker%2F39837989&utm_medium=issues&utm_source=github)** We accept bounties via [Bountysource](https://www.bountysource.com/?utm_campaign=plugin&utm_content=tracker%2F39837989&utm_medium=issues&utm_source=github).

[wzrdtales]

No. This is driver dependend, not shared depended. It would be shared if this would apply to all databases though.

Please refer to the driver this belongs to, also are you sure that this works like you described it? And you should also not that this is not a dataType anymore. The dataType actually would be timestamp and with time zone is an option, but not a dataType.

[stanislavt]

Ok, thank you!

Could you tell me please, how can I Add this option?
db.createTable('airline', { id: {type: 'int', primaryKey: true, autoIncrement: true}, name: 'string', created: 'timestamp' }, cb);

[stanislavt]

Can I add index for column while creating the new table?

[wzrdtales]

Only primary keys currently, so no not as of now.

To your other question: Not without having a new constraint added to the pg driver.
https://github.com/db-migrate/pg/blob/master/index.js#L268

[stanislavt]

Thanks a lot!

[wzrdtales]

@stanislavt No problem, if you plan to go for a PR on the postgres driver, please feel welcome to do so. I'm always here and open for opinions and questions. If you need or want to know anything, just let me know and I will see what I can do.