Re: \copy...
От | Christopher Sawtell |
---|---|
Тема | Re: \copy... |
Дата | |
Msg-id | 00062111431102.28828@berty обсуждение исходный текст |
Ответ на | \copy... ("Ed" <ed@jetumele.com>) |
Список | pgsql-sql |
On Fri, 16 Jun 2000, 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?!?! 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 4451ICQ UIN 45863470EMAIL chris @ iopen. co . nz, csawtell @ xtra . co . nzWWW http://www.iopen.co.nzCNOTES 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 <<--
В списке pgsql-sql по дате отправления: