Thread: passing column name to a plpgsql function for ALTER TABLE ADD

Hello.

Is it possible? I would like to do something like
CREATE OR REPLACE FUNCTION add_column(name, anyelement) RETURNS integer AS '
  DECLARE
    col_name ALIAS FOR $1;
    def_val  ALIAS FOR $2;
  BEGIN
    ALTER TABLE my_table ADD col_name def_val%TYPE;
    RETURN 0;
  END;
' LANGUAGE plpgsql;
SELECT add_column('a', 1);
--
Alexander Kotelnikov
Saint-Petersburg, Russia