Answer the question
In order to leave comments, you need to log in
How to insert 300 rows into a table?
How to insert 300 rows into a table:
CREATE TABLE table_Number(
key integer NOT NULL,
tstamp timestamptz NOT NULL);
Answer the question
In order to leave comments, you need to log in
Still, it was easier to make key serial.
insert into table_Number (key, tstamp)
select * from (
select row_number() over () n, t
from generate_series(NOW() - INTERVAL '90 days', NOW(),'1 min') t
) sq
where n <= 300
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question