title: PostgreSQL : converting existing double precision column to integer data type
body: <p>I have a column in PostgreSQL that contains numbers. The column's data type is double precision, and the numbers have a lot of decimal digits. I don't need that level of accuracy. Integers would be enough. </p>
  
  <p>How do I redefine the column as having an integer datatype, while rounding the current existing data to obtain integers ?</p>