create table active_servers_mv( sort_order integer, server_id bigint, server_name character varying(128), play_time interval, create_dt timestamp without time zone default (now() at time zone 'UTC'), CONSTRAINT active_servers_mv_pk PRIMARY KEY (sort_order) ); ALTER TABLE xonstat.active_servers_mv OWNER TO xonstat;