postgresql – replace all instances of a string within text field

In postgresql, how do I replace all instances of a string within a database column?

Say I want to replace all instances of cat with dog, for example.

What’s the best way to do this?