CREATE TABLE device_events (
id varchar not null primary key,
ts timestamp with time zone not null,
body varchar not null
) with ('materialized' = 'true');
error: Not yet implemented
Support for SQL type 'TIMESTAMP_TZ(0) NOT NULL' not yet implemented:TIMESTAMP_TZ(0)
Assuming that this advice is correct:
https://wiki.postgresql.org/wiki/Don%27t_Do_This#Don't_use_timestamp_(without_time_zone)