postgresql造1000w测试数据

最新推荐文章于 2024-07-12 14:26:59 发布

weixin_41387613

最新推荐文章于 2024-07-12 14:26:59 发布

阅读量704

点赞数

文章标签：数据库 sql postgresql

本文链接：https://blog.csdn.net/weixin_41387613/article/details/129023473

版权

–创建测试数据

CREATE TABLE test (
 serialno varchar(100),
 handlingstaff varchar(100),
 operatedate date
);
INSERT INTO test
SELECT 
	'val'||v serialno,
	'work'||ceil(random()*1000) handlingstaff,
	CURRENT_DATE-cast(random()*365 as integer)  operatedate
FROM generate_series(1, 10000000) v;

–循环插入数据

DO $$
BEGIN
	FOR i IN 1..50000 BY 1 LOOP
		INSERT INTO test_a
	SELECT 
		'val'||v serialno,
		'work'||ceil(random()*1000) handlingstaff,
		CURRENT_DATE-cast(random()*365 as integer)  operatedate
	FROM generate_series(1,200) v;
	END LOOP;
END $$;