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
原创
2021-09-26 20:39:51 ·
579 阅读 ·
0 评论