Not just Psycho but Scorsese's Taxi Driver, The film is dedicated to him; he died soon after completing the score. He was also a composer of classical music....I recommend his Moby Dick Cantata.

However, Bernard Herrman who conducted the band on The Good Old Days was a different guy. His career was in TV programmes.