command copy and type char(x) - Mailing list pgsql-sql

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@message.fucam.ac.be
Téléphone         00 32 65 666301.