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 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42
| -- Create function
CREATE OR REPLACE FUNCTION export_text () RETURNS TRIGGER AS
$BODY$
DECLARE
str_date varchar(20);
path varchar(200);
command varchar(1000);
BEGIN
str_date:=NEW.string_date;
path:='''C:/o/d_'||NEW.string_date||'.txt''';
command:= 'copy (select station,
x_long,
y_lat,
...
id_thunder,
id_tornado from fr_30y where tmp = '''||str_date||''' ) to '||path||';';
execute command;
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();
--*/
--delete from all_date;
--Insert into all_date (string_date,date_)
-- values('19790104',to_date('19790104','YYYYMMDD')),
-- ('19790110',to_date('19790110','YYYYMMDD'));
-- select distinct(tmp),date_ from fr_30y;
Insert into all_date (string_date)
values('20031225'),
('19881008'),
('20070819'),
...
...
('20100215'); |
Partager