Civil Engineering: Useful for space station and space colony design.
Aerospace Engineering: The structure and design of spacecraft.
Mechanical Engineering: The propulsion of a spacecraft.
Since launch costs are the major factor in preventing the space economy from dawning, I'm going to be a Mechanical Engineer.
*: Yes, I'm going to Columbia University.