Skip site navigation (1) Skip section navigation (2)

\copy...

From: "Ed" <ed(at)jetumele(dot)com>
To: "pgsql sql" <pgsql-sql(at)postgresql(dot)org>
Subject: \copy...
Date: 2000-06-15 18:32:13
Message-ID: 001001bfd6f8$06761a60$b48c29d1@citenet.net (view raw or flat)
Thread:
Lists: pgsql-sql
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.



Responses

  • Re: \copy... at 2000-06-20 23:37:34 from Christopher Sawtell

pgsql-sql by date

Next:From: DalTech - Continuing Technical EducationDate: 2000-06-15 18:38:35
Subject: Does anyone know of a function equivilant to Oracle's decode function?
Previous:From: John McKownDate: 2000-06-15 18:17:50
Subject: Re: Simple search question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group