Received: from cti13.citenet.net (cti13.citenet.net [206.123.38.75])
	by hub.org (8.10.1/8.10.1) with ESMTP id e5FIXOI60171
	for <pgsql-sql@postgresql.org>; Thu, 15 Jun 2000 14:33:24 -0400 (EDT)
Received: from zack (g92-180.citenet.net [209.41.140.180])
	by cti13.citenet.net (8.9.3/8.9.1) with SMTP id OAA98911
	for <pgsql-sql@postgresql.org>; Thu, 15 Jun 2000 14:21:55 -0400 (EDT)
From: "Ed" <ed@jetumele.com>
To: "pgsql sql" <pgsql-sql@postgresql.org>
Subject: \copy...
Date: Thu, 15 Jun 2000 14:32:13 -0400
Message-ID: <001001bfd6f8$06761a60$b48c29d1@citenet.net>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 8bit
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook 8.5, Build 4.71.2173.0
Importance: Normal
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200
X-Archive-Number: 200006/178

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.