Sigmund Freud never said that. It’s been appropriated to him erroneously for many years now.
Freud did say, “sometimes a cigar is just a cigar”.