Received: from web805.mail.yahoo.com (web805.mail.yahoo.com [128.11.23.65]) by hub.org (8.10.1/8.10.1) with SMTP id e5KGubM64755 for ; Tue, 20 Jun 2000 12:56:37 -0400 (EDT) Received: (qmail 11914 invoked by uid 60001); 20 Jun 2000 16:56:36 -0000 Message-ID: <20000620165636.11913.qmail@web805.mail.yahoo.com> Received: from [169.2.229.24] by web805.mail.yahoo.com; Tue, 20 Jun 2000 09:56:36 PDT Date: Tue, 20 Jun 2000 09:56:36 -0700 (PDT) From: Webb Sprague Subject: Re: \copy... To: Ed , pgsql sql MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200006/181 Finally--a question I think I can answer! You need to specify what delimiters you use in your .dat file; the default for COPY is tab, but you can change that to | with copy tablename from '/home/ed/import.dat' delimiters '|' Hope this works...(oops--I mean 'helps') --- Ed wrote: > Hi, > > I have a file that look like this : > > firstname|lastname|email@domain.com > firstname2|lastname2|email2@domain.com > > and a table foo like : > > firstname varchar(30), > lastname varchar(30), > email varchar(50) > > and I would like to do a : > > copy tablename from '/home/ed/import.dat'; > > But then, everything goes in the first field... what > does i'm doing > wrong?!?! > > Frédéric Boucher > Ed@jetumele.com > Programmation, Support technique > Jetumele Communications inc. > > __________________________________________________ Do You Yahoo!? Send instant messages with Yahoo! Messenger. http://im.yahoo.com/