Received: from message.fucam.ac.be (message.fucam.ac.be [193.190.244.2]) by hub.org (8.9.1/8.9.1) with ESMTP id CAA01053 for ; Tue, 15 Dec 1998 02:41:19 -0500 (EST) (envelope-from koul@message.fucam.ac.be) Received: from message.fucam.ac.be (fucam81.fucam.ac.be [193.190.244.81]) by message.fucam.ac.be (8.9.0/8.9.0) with ESMTP id IAA04773 for ; Tue, 15 Dec 1998 08:38:03 +0100 (MET) Message-ID: <3676129D.68259ED@message.fucam.ac.be> Date: Tue, 15 Dec 1998 08:41:17 +0100 From: KOUL Christian Organization: Groupe GTM - FUCAM X-Mailer: Mozilla 4.5 [en] (Win95; I) X-Accept-Language: fr,en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: command copy and type char(x) Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit 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.