CREATE TABLE tbl_tmp (  
 id bigint DEFAULT nextval('public.tbl_tmp_id_seq'::regclass),  
 host character varying(50),  
 remoteip character varying(50),  
 ntime timestamp without time zone,  
 reqdesc character varying(2000),  
 httpcode character varying(10),  
 clength integer,  
 refer character varying(2000),  
 agent character varying(50),  
 hsman character varying,  
 hstype character varying(50),  
 imsi character varying(50)  
);

CREATE OR REPLACE FUNCTION skytf.create_table()  
RETURNS void  
LANGUAGE plpgsql  
AS $function$  
declare
v_date char(8);  
v_tablename varchar(64);
begin  
  
for i in 0..1500 loop
v_date :=to_char(current_date + i,'YYYYMMDD');  
v_tablename := 'tbl_tmp_' || v_date;
execute 'create table ' || v_tablename || ' (like tbl_tmp including constraints including indexes including defaults) inherits (tbl_tmp)';  
execute 'grant select on skytf.' || v_tablename || ' to dwetl';
end loop;  
end  
$function$;