postgre 修改表字段默认值

修改表字段默认值

alter table alf_authority alter column downloadflag set default 'true';
alter table alf_authority alter column   visible               set default '1';    
alter table alf_authority alter column   glance                set default '1';    
alter table alf_authority alter column   versions              set default '1';    
alter table alf_authority alter column   reuse                 set default '1';    
alter table alf_authority alter column   xcopy                 set default '1';    
alter table alf_authority alter column   modification          set default '1';    
alter table alf_authority alter column   newfile               set default '1';    
alter table alf_authority alter column   deletefile            set default '1';    
alter table alf_authority alter column   pigeonhole            set default '1';    
alter table alf_authority alter column   cancelpigeonhole      set default '1';    
alter table alf_authority alter column   change                set default '1';    
alter table alf_authority alter column   abolish               set default '1';    
alter table alf_authority alter column   export                set default '1';    
alter table alf_authority alter column   print                 set default '1';    
alter table alf_authority alter column   authorizationuser     set default '1';    
alter table alf_authority alter column   publish               set default '1';    
alter table alf_authority alter column   lookover              set default '1';    
alter table alf_authority alter column   cutting               set default '1';    
alter table alf_authority alter column   borrow                set default '1';    
alter table alf_authority alter column   workflow              set default '1';    
alter table alf_authority alter column   recycle               set default '1';