Received: from smtp012.mail.yahoo.com (smtp012.mail.yahoo.com [216.136.173.32]) by postgresql.org (8.11.3/8.11.1) with SMTP id f6HMjpa26255 for ; Tue, 17 Jul 2001 18:45:51 -0400 (EDT) (envelope-from chrup999@yahoo.com) Received: from chill-025.bbnow.net (HELO ?192.168.0.4?) (24.219.2.25) by smtp.mail.vip.sc5.yahoo.com with SMTP; 17 Jul 2001 22:45:47 -0000 X-Apparently-From: User-Agent: Microsoft-Entourage/9.0.1.3108 Date: Tue, 17 Jul 2001 17:45:33 -0500 Subject: Re: PL/PGSQL and external (flat ASCII) files - Urgent ... :) From: Chris Ruprecht To: "pgsql-sql@postgresql.org" Message-ID: In-Reply-To: <26545.995404013@sss.pgh.pa.us> Mime-version: 1.0 Content-type: text/plain; charset="US-ASCII" Content-transfer-encoding: 7bit X-Archive-Number: 200107/236 X-Sequence-Number: 4032 Hi Tom, If life was easy, everything would just come in the format I'd like it. But since it isn't, I need to create records like this one: cdate | ctime | countrycode | areacodex | success | carrier | duration| phonenumber | areacode | pseq | loadno | frline | entity | loaddate | loadtime | prefix | toline | dur306 | dur180180 | recno ------------+----------+-------------+-----------+---------+---------+------ ----+-------------+----------+------+---------+--------+--------+----------- -+----------+--------+--------+--------+-----------+--------- 2001-07-15 | 23:55:52 | 98 | 0 | f | 53092 | 48| 11970 | | 0 | 8280646 | 2017 | 001 | 2001-07-16 | 02:05:48 | 092 | 2116 | 0.8 | 3 | 5493891