I have to look this up every time, so here is how to insert some test data using a loop:
DO
$do$
begin
FOR i IN 1..10
loop
FOR j IN 1..10
LOOP
INSERT INTO ... (...) values ('foo' || i, ...);
END LOOP;
END LOOP;
end
$do$;
-
Follow
Following
Already have a WordPress.com account? Log in now.
Look on my works, ye Mighty, and despair! 