text: --
  -- PostgreSQL database dump
  --
  
  SET client_encoding = 'UTF8';
  SET check_function_bodies = false;
  SET client_min_messages = warning;
  
  --
  -- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres
  --
  
  COMMENT ON SCHEMA public IS 'Standard public schema';
  
  
  --
  -- Name: plpgsql; Type: PROCEDURAL LANGUAGE; Schema: -; Owner: 
  --
  
  CREATE PROCEDURAL LANGUAGE plpgsql;
  
  
  SET search_path = pg_catalog;
  
  --
  -- Name: test_table_trigger(); Type: FUNCTION; Schema: public; Owner: fordfrog
  --
  
  CREATE FUNCTION public.test_table_trigger() RETURNS "trigger"
      AS $$
  begin
  	return NEW;
  end;
  $$
      LANGUAGE plpgsql;
  
  
  ALTER FUNCTION public.test_table_trigger() OWNER TO fordfrog;
  
  SET default_tablespace = '';
  
  SET default_with_oids = false;
  
  --
  -- Name: test_table; Type: TABLE; Schema: public; Owner: fordfrog; Tablespace: 
  --
  
  CREATE TABLE public.test_table (
      id serial NOT NULL
  );
  
  
  ALTER TABLE public.test_table OWNER TO fordfrog;
  
  CREATE VIEW public.test_view AS 
      SELECT test_table.id FROM public.test_table;
  
  --
  -- Name: test_table_trigger; Type: TRIGGER; Schema: public; Owner: fordfrog
  --
  
  CREATE TRIGGER test_table_trigger
      BEFORE INSERT OR UPDATE OF id ON public.test_table
      FOR EACH ROW
      EXECUTE PROCEDURE public.test_table_trigger();
  
  CREATE TRIGGER test_view_trigger1
      INSTEAD OF INSERT OR UPDATE ON public.test_view
      FOR EACH ROW
      EXECUTE PROCEDURE public.test_table_trigger();
  
  --
  -- Name: public; Type: ACL; Schema: -; Owner: postgres
  --
  
  REVOKE ALL ON SCHEMA public FROM PUBLIC;
  REVOKE ALL ON SCHEMA public FROM postgres;
  GRANT ALL ON SCHEMA public TO postgres;
  GRANT ALL ON SCHEMA public TO PUBLIC;
  
  
  --
  -- PostgreSQL database dump complete
  --
  
  