如何使用特定的列名更新所有表

获取您条件的更新查询

     select         'update '||c.table_name||' set '||c.COLUMN_NAME||' = ''rajeev'';'          as my_update_query     from         (select  table_name,COLUMN_NAME         from INFORMATION_SCHEMA.COLUMNS          where table_name LIKE 'agg%' and COLUMN_NAME LIKE '%userid%') c

执行

 do $$  declare    arow record;  begin    for arow in    select         'update '||c.table_name||' set '||c.COLUMN_NAME||' = ''rajeev'';'          as my_update_query     from         (select  table_name,COLUMN_NAME         from INFORMATION_SCHEMA.COLUMNS          where table_name LIKE 'agg%' and COLUMN_NAME LIKE '%userid%') c    loop     execute arow.my_update_query;    end loop;  end;$$;