create table pg_temp.test(
id serial primary key,
title text,
author_id int,
created date
);
insert into pg_temp.test (title, author_id, created)
select md5(random()::text),(100*random())::int,now() - '1 day'::interval * (random()::int * 100 + 100)
from generate_series(1,10)
Оставить комментарий