todo_api_postgresql.sql

begin transaction ;

drop schema restapi cascade;

create schema restapi;

commit;

begin transaction ;


--drop table if exists restapi.todos;

create table if not exists restapi.todos (
  id bigint GENERATED ALWAYS AS IDENTITY  (MINVALUE 0 START WITH 0 CACHE 20) PRIMARY KEY,
  "uuid" uuid not null,
  done boolean not null default false,
  task text not null,
  due timestamptz
);

insert into restapi.todos (task, uuid) values
  ('finish tutorial 0', gen_random_uuid() ), ('pat self on back', gen_random_uuid());
  
commit;

select * from restapi.todos;