title: Postgres Alter table to convert column type from char to bigint
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/7683359/how-to-change-column-datatype-from-character-to-numeric-in-postgresql-8-4">how to change column datatype from character to numeric in postgresql 8.4</a>  </p>
  </blockquote>
  
  
  
  <p>If I have a field of type varchar (and all the values are null or string representations of numbers) how do I use alter table to convert this column type to bigint?</p>