the cooking show said that they have a pumpkin that is called a sugar pumpkin.. personally i have never seen them.. i have only seen the
Halloween pumpkin..maybe they have them at the farmers market..

Selecting the Pumpkin - Pies

When selecting a pumpkin for making a pie, be sure to choose a small pumpkin that is a variety specifically grown for eating, such as sugar, cheese, or milk pumpkins. They may also be called pie pumpkins and generally weigh from 2 to 4 pounds. Do not select the Jack-O-Lantern variety, which is not as sweet and has flesh that is tough and stringy. Select one that has good orange coloring and is heavy for its size. It should be firm, free of blemishes and have its stem intact. Pie pumpkins will yield approximately 1 cup of puree per pound of pumpkin.
http://www.recipetips.com/kitchen-tips/t...