--1创建函数
CREATE OR REPLACE FUNCTION "public"."exec"("sqlstring" varchar)
RETURNS "pg_catalog"."varchar" AS $BODY$
declare
res varchar(50);
BEGIN
EXECUTE sqlstring;
RETURN 'ok';
END
$BODY$
LANGUAGE plpgsql VOLATILE
COST 100
-- 2根据条件查询aa_bb表,所有大写的column
select * from information_schema.columns where table_schema = 'public' AND table_catalog = 'ry-vue' and table_name = 'aa_bb';
-- 3修改条件后,通过下列语句转换column_name中的大写字母 大小写转换upper/lower
SELECT
exec('alter table "' || table_name || '" rename column "' || column_name || '" to "' || upper( column_name ) || '";')
FROM
information_schema.COLUMNS
WHERE
table_schema = 'public'
AND