20240226_step2.sql 429 B

1234567891011121314
  1. create sequence application_log_history_seq;
  2. create table application_log_history
  3. (
  4. id integer not null primary key default nextval('public.application_log_history_seq'),
  5. started timestamp not null,
  6. message text,
  7. data jsonb,
  8. login varchar(100) default current_user
  9. );
  10. --row_to_json(data)
  11. --SELECT * FROM jsonb_populate_record(NULL::temperature_correction, '{"calc_height_id": 1, "height": 50, "deviation": 10}'::jsonb);