Vacuum a PostgreSQL schema's tables via dblink

vacuum_schema.sql

-- requires dblink extension the be installed
-- vacuum a schema via dblink
create or replace function vacuum_schema(schemaname text)
returns void
language plpgsql
as

$func$

declare
    rec record;
begin
    -- fix connstr here to suit
    perform dblink_connect('dbname='|| current_database());
    for rec in
        select relname
        from pg_class c
             join pg_namespace n
                  on c.relnamespace = n.oid
                     and n.nspname = schemaname
        where c.relkind in ('r','m')
    loop
        perform dblink('VACUUM ' || quote_ident(schemaname) || '.' 
                                 || quote_ident(rec.relname));
    end loop;
    perform dblink_disconnect();
end;

$func$;