How to alter column from float(8) to numeric(64,8)
ALTER TABLE your_table 
   ALTER COLUMN the_float_column TYPE numeric(64,8);


More details in the manual: http://www.postgresql.org/docs/current/static/sql-altertable.html