On Fri, 16 Jun 2000, Ed wrote:
> 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?!?!
You are nearly there, use:-
copy tablename from '/home/ed/import.dat' using delimiters '|';
see sql-copy.htm in online doco.
--
Sincerely etc.,
NAME Christopher Sawtell - iOpen Technologies Ltd.
CELL PHONE 021 257 4451
ICQ UIN 45863470
EMAIL chris @ iopen . co . nz, csawtell @ xtra . co . nz
WWW http://www.iopen.co.nz
CNOTES ftp://ftp.funet.fi/pub/languages/C/tutorials/sawtell_C.tar.gz
-->> Please refrain from using HTML or WORD attachments in e-mails to me <<--
