title: PostgreSQL Convert column from integer to text
body: <p>I have a PostgreSQL (9.0) database with a column card_id which is currently of type integer</p>
  
  <p>I need to change this to type text</p>
  
  <p>What is the most best way to achieve this?</p>
  
  <p>The only solution I can find involves creating a temporary column, dropping the original then renaming, I thought they might be a better method??</p>