postgres的update_time设置

create or replace function upd_timestamp() returns trigger as
$$
begin
  new.update_time = current_timestamp;
  return new;
end
$$
language plpgsql;
create or replace function cre_timestamp() returns trigger as
$$
begin
  new.create_time= current_timestamp;
  return new;
end
$$
language plpgsql;
 
drop table if exists fire_user;
create table fire_user(id serial NOT NULL,  
  username character varying,  
  email character varying,
 password character varying,  
 name character varying, 
status int,
phone character varying,
 creator character varying, 
  create_time   timestamp default current_timestamp,
 update_time   timestamp default current_timestamp,
user_group character varying,
language character varying,
avatar character varying,
PRIMARY KEY (id ));
create trigger t_name before update on fire_user  for each row execute procedure upd_timestamp();
create trigger z_name before insert on fire_user  for each row execute procedure cre_timestamp();

不知道为什么直接从txt文本复制到db能执行，但是直接copy的网页这段却不能执行，大家要用的话，先copy到文本再copy到db执行