From: Ed <ed@jetumele.com>
To: pgsql sql <pgsql-sql@postgresql.org>
Subject: \copy...
Date: Thu, 15 Jun 2000 14:32:13 -0400
Message-ID: <001001bfd6f8$06761a60$b48c29d1@citenet.net> (raw)
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: ed@jetumele.com
Subject: Re: \copy...
In-Reply-To: <001001bfd6f8$06761a60$b48c29d1@citenet.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox