Re: \copy... - Mailing list pgsql-sql

From Christopher Sawtell
Subject Re: \copy...
Date
Msg-id 00062111431102.28828@berty
Whole thread Raw
In response to \copy...  ("Ed" <ed@jetumele.com>)
List 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 by date:

Previous
From: Ed Loehr
Date:
Subject: Re: Type conversion
Next
From: Ryan Kirkpatrick
Date:
Subject: Sequences do not obey transactions...