1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26
| -- Create function
CREATE OR REPLACE FUNCTION export_text () RETURNS TRIGGER AS
--Declaration d'une variable locale
$BODY$
DECLARE
str_date varchar(20);
BEGIN
-- on met dans la variable locale le max de la colonne
str_date:=TG_ARGV[1];
copy (select * from fr_30y where tmp = to_char(str_date) ) to 'C:/o/d_''str_date''.txt';
NEW.valid:=1;
RETURN NEW;
END;
$BODY$
LANGUAGE 'plpgsql';
--Creation du trigger
DROP TRIGGER trig_txt_date ON all_date;
CREATE TRIGGER trig_txt_date AFTER INSERT ON all_date
FOR EACH ROW
EXECUTE PROCEDURE export_text();
--*/
insert into all_date(string_date,date_)
values('20120927', to_date('20120927','YYYYMMDD')); |
Partager