When does one say "pez" or "pescado"?

In Spanish there is a distinction between the fish you see in an aquarium, or the one that's on your plate. As such, one can swim with "peces", and will enjoy a fine dish of "pescado".