[SQL] \copy...

[Ed]

Hi,

I have a file that look like this :

firstname|lastname|[EMAIL PROTECTED]
firstname2|lastname2|[EMAIL PROTECTED]

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
[EMAIL PROTECTED]
Programmation, Support technique
Jetumele Communications inc.