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.