create table user_info
(userid int,
name text,
birthday date,
crt_time timestamp without time zone,
);
insert into user_info (userid,name,birthday,qq,crt_time)
select generate_series(1,100000),
‘abcdef‘,
‘2015-08-10‘,
clock_timestamp()
;
原文：http://www.cnblogs.com/songyuejie/p/4718557.html