question

There's no way to create constraints to tables, which have been created using CTAS, is there? Does anyone know a workaround? I don't want to set all the columns manually.

testcase

D CREATE TABLE test AS SELECT * FROM read_csv('test.csv', sample_size = 9E18);
D ALTER TABLE test ADD CONSTRAINT unique_constraint UNIQUE (col1, col2, col3);
Not implemented Error: No support for that ALTER TABLE option yet!

possible workaround

Export the database and do some shell-scripting on schema.sql. Ugly.

D EXPORT DATABASE 'test;