Most people in US will know this as the pumpkin puree you get out of a can. In Australia you’ll have a hard time finding pumpkin puree in a can. Making your own using fresh pumpkin will always taste better. It may be a few extra steps but you get so much more in doing it yourself from scratch. If time is an issue, then you cannot beat the convenience of opening up a can.
The name pumpkin quite often can get confused between pumpkin and squash. Different countries use different names but they are both from the same species known as the cucurbitaceae. Basically a pumpkin is a type of squash. The best pumpkin to use will be the denser sweeter types with little water such as sugar pumpkin or sweet pumpkin!