CREATE OR REPLACE FUNCTION import_text_file(char(255)) RETURNS void AS $$ DECLARE filename ALIAS FOR $1; fin varchar; BEGIN fin := 'COPY table from ' || filename; execute fin; END; $$ LANGUAGE plpgsql;
> CREATE OR REPLACE FUNCTION import_text_file(char(255)) RETURNS void AS $$ > DECLARE > filename ALIAS FOR $1; > BEGIN > COPY table FROM filename; > END; > $$ LANGUAGE plpgsql;
Use EXECUTE.
regards, tom lane
---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster