Dynamic table name in query

dynamic-query.sql

DO $$ 
DECLARE 
  r record;
BEGIN
  FOR r IN SELECT tablename FROM pg_catalog.pg_tables WHERE tablename LIKE 'schema_%%' LOOP
    EXECUTE 'UPDATE ' || quote_ident(r.tablename) || ' SET host_added = ''54auto.ru'' WHERE host_added = ''54.ruauto.ru''';
  END LOOP;
END $$ LANGUAGE plpgsql;