command copy and type char(x)

Hello;

I have a file containing lines like the following one

0121,0000000209,000000207,0,001,1,0000000999,0000000999,0000000999,

When i use COPY my_table FROM the_file USING DELIMITERS ',' I am obliged
to create all columns of my_table as char(x).
If i want to make calculus with the fields of my table, How can i make
to tranform thoses fieds as integer or float in postgresSQL v6.4

Thanks.

--
Ir. Christian Koul.
Groupe Transport Mobilité - Fucam.
E-mail: koul(at)message(dot)fucam(dot)ac(dot)be
Téléphone 00 32 65 666301.