2021-09-26 sql语句修改PGSQL/瀚高——＞表名、字段名为小写

创建exec(sqlstring)函数方便执行，其中table_schema=‘public’ ，public为模式名

select * from information_schema.columns 
where table_schema='public' 
and table_name<>'pg_stat_statements' 
and column_name <> lower(column_name);

查询大写字段名

create or replace function f_exec()
	returns void as $$
	declare 
		x varchar(500);
begin
	for x in(
	SELECT
    'alter table "' || table_name || '" rename column  "' || column_name || '" to ' || lower( column_name ) || ';' alter_column
FROM
    information_schema.columns 
WHERE
    table_schema = 'public' 
    AND column_name <> lower(column_name)
    AND table_name<>'pg_stat_statements') 
	loop
		execute  x ;
    end loop;
end;
$$ language plpgsql;

执行sql

select f_exec();