Advertisement
Guest User

xd

a guest
Mar 23rd, 2017
61
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.42 KB | None | 0 0
  1. CREATE OR REPLACE FUNCTION criaTabelaPopulada() RETURNS VOID AS
  2. $BODY$
  3. DECLARE
  4. i INTEGER;
  5. BEGIN
  6. i := 1;
  7. CREATE TABLE empregado(
  8. id serial, nome varchar(100), matricula integer);
  9. LOOP
  10. INSERT INTO empregado (nome, matricula) VALUES ('teste', i);
  11. EXIT WHEN i > 1000000;
  12. i :=+1;
  13. END LOOP;
  14. END;
  15. $BODY$
  16. LANGUAGE plpgsql VOLATILE
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement