\copy... - Mailing list pgsql-sql

From Ed
Subject \copy...
Date
Msg-id 001001bfd6f8$06761a60$b48c29d1@citenet.net
Whole thread Raw
Responses Re: \copy...  (Christopher Sawtell <csawtell@xtra.co.nz>)
List pgsql-sql
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?!?!

Frédéric Boucher
Ed@jetumele.com
Programmation, Support technique
Jetumele Communications inc.




pgsql-sql by date:

Previous
From: Toshihide Nakamura
Date:
Subject: SQL92 and Traditional
Next
From: "DalTech - Continuing Technical Education"
Date:
Subject: Does anyone know of a function equivilant to Oracle's decode function?