gistfile1.txt

CREATE OR REPLACE FUNCTION trigger_fooview_before_insert()
  RETURNS trigger AS $$
  DECLARE _q varchar; 

  BEGIN

   _q := (SELECT execute(('CREATE TABLE IF NOT EXISTS sch.foo (i integer')::text) WHERE NOT EXISTS(SELECT * FROM information_schema.tables WHERE table_schema = 'sch' AND table_name = 'foo')) ;

   EXECUTE 'INSERT INTO sch.foo VALUES('|| NEW.i::text ||')';

   RETURN NEW;

  END;
  $$ LANGUAGE plpgsql