Missing parameter in CREATE TABLE for disabling columnstore

TimescaleDB and PostgreSQL
,
1

Hi all!

@jonatasdp , @sven The new syntax of CREATE TABLE is convenient but missing property for the hypertable to be created in rowstore mode. It would be greate to add one parameter such as `columnstore`. Not all tables should be compressible, and there is no way to create a trigger on delete for columnstore. Is there a way to add such a property?

I can manually disable columnstore, but it is not convenient.

Thanks in advance.

2

You can create hypertable with columnstore disabled like so:
CREATE TABLE t(time timestamptz) WITH (tsdb.hypertable,tsdb.columnstore=false);