SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE logs ( id bigserial NOT NULL, datetime int8 NOT NULL, application varchar(16) NULL, "level" varchar(8) NULL, message varchar(255) NULL, "exception" varchar(255) NULL, operation int2 NOT NULL DEFAULT 0, login int8 NOT NULL DEFAULT 0 ) PARTITION BY RANGE (datetime); CREATE INDEX logs_datetime_brin_idx ON ONLY logs USING brin (datetime); CREATE INDEX logs_id_idx ON ONLY logs USING btree (id); CREATE INDEX logs_login_index ON ONLY logs USING btree (login) WHERE (login > 0); CREATE TABLE logs_2022_01 PARTITION OF public.logs FOR VALUES FROM ('1640995200') TO ('1643673600'); insert into logs_2022_01 values (1, 1640995201, '', '', '', '', 0, 0); select * from logs; alter table logs ALTER COLUMN "message" TYPE varchar(512), ALTER COLUMN "exception" TYPE varchar(512);
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear