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!