PostgreSQL 批量生成数据

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()
;

PostgreSQL 批量生成数据

标签：