Auto create a large csv file with powershell,plsql

I need a large table to test database performance, so i noted my simple script for creating large csv file.

powershell
$count = 9999999999999

for ($i=1; $i -le $count; $i++)
{
  $line = $i.ToString() + “,” + “Thora,Temple,2013-05-26 14:47:57” ;
  Add-Content C:\Users\Hieu\actor_202102111552.csv $line;
}

plsql
CREATE OR REPLACE FUNCTION public.insertTable() RETURNS void AS $$
DECLARE
BEGIN
FOR counter IN 1..922337203
loop
     INSERT INTO public.actor
	(first_name, last_name, last_update)
	VALUES('Penelope', 'Guiness', now());

END LOOP;
END;
$$ LANGUAGE plpgsql;

Well done!!!

Maybe you need it.

Thank you for reading the DevopsRoles page!