Support CTAS statement USING columnstore

[ktny]

What feature are you requesting?

I want to create a columnstore table with a CREATE TABLE AS SELECT statement.

create table t1 (id int, name text);
insert into t1 values (1, 'Alice'), (2, 'Bob');
create table t2 using columnstore as select * from t1;

ERROR:  columnstore_tuple_insert not implemented

CTAS WITH NO_DATA is not a problem.

create table t2 using columnstore as select * from t1 with no data;

Why are you requesting this feature?

Because the CTAS statement is convenient for creating a columnstore table while copying part of a table.

What is your proposed implementation for this feature?

No response

[dpxcc]

Yes, this is on our roadmap
Before we support it, you can work around by

create table t2 using columnstore as select * from t1 with no data;
insert into t2 select * from t1;

[dpxcc]

duckdb/pg_duckdb@4a7596c