Where do you recharge a card from?
You have it right: from the hand.
From this thread on Paizo:

Unless a specific card says otherwise (for example, as you say, the Sandpoint Cathedral), you can't recharge a card from the discard pile. &quot;Recharging&quot; is a &quot;playing a card&quot; action (p. 10) and you can only play cards from your hand.