Received: from cdg.co.th (isimail.cdg.co.th [157.179.9.195]) by hub.org (8.8.8/8.7.5) with SMTP id FAA10992 for ; Mon, 6 Jul 1998 05:29:53 -0400 (EDT) Received: from zeus.cdg.co.th by cdg.co.th (SMI-8.6/SMI-SVR4) id QAA10014; Mon, 6 Jul 1998 16:30:50 -0700 Message-ID: <35A09973.15A3@cdg.co.th> Date: Mon, 06 Jul 1998 16:31:31 +0700 From: Korapat Charukumnerdkanok X-Mailer: Mozilla 3.03Gold (Win95; I) MIME-Version: 1.0 To: pgsql-general@postgreSQL.org Subject: :) Import file2table Question Content-Type: multipart/mixed; boundary="MimeMultipartBoundary" --MimeMultipartBoundary Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Good Morning, @^_^@ Could you please tell me .... 1 -How can I import a text file into Postgres table ? (append to the last row) -What is the format of that text file ? This is what I've done and its result.... ProjDB=> copy PrjTB from /prj_data/test.txt using delimiters , ProjDB-> ; ERROR: parser: syntax error at or near "/" 2 -What table field type that suits for 6-digit decimal number.. (i.e. 0.000000, 0.250001 , 0.123456 , ....)? I've defined this column with float4 and float8 but when I inserted data it returned this error message.. ProjDB=> insert into PrjTB values (0.000000,'red','Ln1') ProjDB->; ERROR: pg_atoi: error in "0.000000": can't parse ".000000" Thank You for your advance help, Korapat Charu. --MimeMultipartBoundary--