批量修改表名或字段
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 ;
select * from information_schema. columns where table_schema= 'public' and table_name<> 'pg_stat_statements' and column_name <> lower( column_name) ;
SELECT
exec ( 'alter table "' || table_name || '" rename column "' || column_name || '" to ' || lower( column_name ) || ';' )
FROM
information_schema. COLUMNS
WHERE
table_schema = 'public'
AND column_name <> lower( column_name)
AND table_name <> 'pg_stat_statements'
AND table_name in ( 't_ga_rjbxx' , 't_ga_fwjbxx' , 'sys_people_info' , 't_zp_edz' , 't_zp_jzz' ) ;
SELECT * FROM information_schema. TABLES WHERE table_schema = 'public' AND table_catalog = 'Guns' AND table_name <> lower( table_name ) ;
SELECT
exec ( 'alter table "' || table_name || '" to ' || lower( table_name ) || ';' )
FROM
information_schema. tables
WHERE
table_schema= 'public'
and table_catalog = 'Guns'
and table_name <> lower( table_name) ;