Project

General

Profile

« Previous | Next » 

Revision 9824

schemas/util.sql: added eval() to allow running EXECUTE outside of a function (and to echo the command that is run)

View differences:

schemas/util.sql
687 687

  
688 688

  
689 689
--
690
-- Name: eval(text); Type: FUNCTION; Schema: util; Owner: -
691
--
692

  
693
CREATE FUNCTION eval(sql text) RETURNS void
694
    LANGUAGE plpgsql STRICT
695
    AS $$
696
BEGIN
697
    RAISE NOTICE '%', sql;
698
    EXECUTE sql;
699
END;
700
$$;
701

  
702

  
703
--
690 704
-- Name: existing_cols(regclass, text[]); Type: FUNCTION; Schema: util; Owner: -
691 705
--
692 706

  

Also available in: Unified diff