Add default value to column

Community
1

I have a table in CrateDB, and I need to add the default value for a column of type timestamp with time zone. How can I do that? My CrateDB version is 5.10.9.

2

Hi, if the table already exists you cannot currently do that, the feature request is tracked at Support `ALTER TABLE x ALTER COLUMN y SET DEFAULT` · Issue #18784 · crate/crate · GitHub

Alternatively as noted in the issue, some manual steps could be done to do this.