I am not aware of any insurance company that provides temporary coverage for a rental car unless you already have a policy covering your automobile.
You should be able to purchase insurance coverage from the car rental agency.