Here's an upcoming product that can literally lift your carved pumpkin a few feet off the ground.
The "Punkin Post" (note the spelling) can a hold real or faux pumpkin. You insert the stand into the ground or bucket full of sand, and mount your pumpkin securely on top.
This model is designed to look like a skeleton hand and is called "Last Grasp." Introductory price is $19.00 plus shipping & handling. I'm told they should become available at the end of August.
Here's a good video that shows the item in action:
And the inventors website is here:
If anyone gives this item a try, please post your review below!