CREATE OR REPLACE FUNCTION reindex_user_tables() RETURNS void AS $_$
DECLARE
  _rec RECORD;
BEGIN
  for _rec in (
    select table_schema||'.'||table_name as table_name
    from information_schema.tables

    where table_type='BASE TABLE'
      and table_schema<>'pg_catalog'
    order by  1 
  ) loop
    raise info 'reindex %s', _rec.table_name;
    execute('REINDEX TABLE '||_rec.table_name);
  end loop;
  return;
END;
$_$ LANGUAGE plpgsql VOLATILE;