DO $$DECLARE rec RECORD;
BEGIN FOR rec IN (
SELECT table_name,column_name FROM information_schema.columns WHERE table_schema = 'public' AND table_name not LIKE 'sys%' and table_name NOT LIKE 'pl_profiler_saved%' AND data_type='timestamp without time zone')
LOOP
EXECUTE FORMAT('ALTER TABLE %I ALTER COLUMN %I TYPE pg_catalog.date', rec.table_name, rec.column_name);
END LOOP;
END $$;
网站声明:如果转载,请联系本站管理员。否则一切后果自行承担。
加入交流群
请使用微信扫一扫!