Advertisement
hackerboxes

create trigger in postgresql

Jul 27th, 2012
262
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.59 KB | None | 0 0
  1. CREATE TABLE geometries
  2. (
  3. name character varying,
  4. geom geometry
  5. );
  6. CREATE TABLE geometries1
  7. (
  8. name character varying,
  9. geom geometry
  10. );
  11. CREATE or Replace FUNCTION func_geom_insert() RETURNS trigger AS $func_geom_insert$
  12. BEGIN
  13. If (TG_OP = 'INSERT') THEN
  14.  
  15. INSERT INTO geometries1(name,geom) values(NEW.name,NEW.geom);
  16. END IF;
  17. return null;
  18. END;
  19. $func_geom_insert$ LANGUAGE plpgsql;
  20. CREATE TRIGGER t_insert_2_table AFTER INSERT ON geometries
  21. FOR EACH ROW EXECUTE PROCEDURE func_geom_insert();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement