postgresql 根据一个schema 创建另一个 schema 包含原schema 所有的表

DO $$
DECLARE
tbl_name text;
BEGIN
FOR tbl_name IN
SELECT table_name
FROM information_schema.tables
WHERE table_schema = 'public'
LOOP
EXECUTE 'CREATE TABLE account2024.' || tbl_name || '() INHERITS (public.' || tbl_name || ')';
END LOOP;
END $$;