pgsql创建更新时间戳字段

添加更新时间触发器

create or replace function upd_timestamp() returns trigger as
$$
begin
    new.ziduan= current_timestamp;
    return new;
end
$$
language plpgsql;

create trigger t_name before update on ATable for each row execute procedure upd_timestamp();