CREATE TABLE IF NOT EXISTS osh.results(
    results_id SERIAL,
    datetime TIMESTAMP WITHOUT TIME ZONE DEFAULT (NOW() AT TIME ZONE 'utc') NOT NULL,
    state BOOLEAN,
    logs bytea,
    task_reference VARCHAR(50),
    PRIMARY KEY (results_id)
);

INSERT INTO osh.results (results_id,datetime,state,logs)
  VALUES(1,'2023-06-22 16:04:04.816453',true,bytea('/home/lbossis/osh/postgres/logs/bulk-load.log.hex'));
INSERT INTO osh.results (results_id,datetime,state,logs)
  VALUES(2,'2023-06-22 16:04:04.816453',true,bytea('/home/lbossis/osh/postgres/logs/inp.log.hex'));
INSERT INTO osh.results (results_id,datetime,state,logs)
  VALUES(3,'2023-06-22 16:04:04.816453',true,bytea('/home/lbossis/osh/postgres/logs/bulk-load.log'));
