PostgreSQL 批量生成数据
2015-08-10 17:13 DataBases 阅读(1245) 评论(0) 编辑 收藏 举报
create table user_info
(userid int,
name text,
birthday date,
crt_time timestamp without time zone,
);
insert into user_info (userid,name,birthday,crt_time)
select generate_series(1,100000),
'abcdef',
'2015-08-10',
clock_timestamp()
;