Change owner of all tables in a database using pure PostgreSQL

change-owner-all-tables.sql

DO
$$
DECLARE
    row record;
BEGIN
    FOR row IN SELECT table_name FROM information_schema.tables
        WHERE table_schema <> 'pg_catalog' AND table_schema <> 'information_schema' AND table_catalog = 'kobotoolbox'
    LOOP
        EXECUTE 'ALTER TABLE ' || quote_ident(row.table_name) || ' OWNER TO kobo;';
    END LOOP;
END;
$$;