generate data with sequence

gen_data.sql

CREATE TABLE dataq_demo.tbl_ItemTransactions1 
 (
     TranID SERIAL
     ,TransactionDate TIMESTAMPTZ
     ,TransactionName TEXT
     
 );

drop table dataq_demo.tbl_ItemTransactions1

INSERT INTO dataq_demo.tbl_ItemTransactions1 
(TransactionDate, TransactionName)
SELECT x, 'dbrnd' 
FROM generate_series('1600-01-01 00:00:00'::timestamptz, '2018-02-01 00:00:00'::timestamptz,'1 minute'::interval) a(x);