Hi,
I have a file that look like this :
firstname|lastname|email(at)domain(dot)com
firstname2|lastname2|email2(at)domain(dot)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(at)jetumele(dot)com
Programmation, Support technique
Jetumele Communications inc.