can anyone share how to use the cli to show the details of a resource in the state file? like the terraform state show

What details are you looking for? You can use

pulumi stack --show-urns

which will show the URNs of the resources in the stack. Within the URNs you can see the type of the resource. Is that what you're looking for

thanks! I think that i found the command, looks like it can be achieved by "pulumi stack export"