Re: import CVS file

From: Neil Conway <nconway(at)klamath(dot)dyndns(dot)org>
To: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: import CVS file
Date: 2000-09-21 02:02:36
Message-ID: 20000920220236.A343@klamath.dyndns.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Sep 20, 2000 at 10:43:17PM -0300, Fernando Lozano wrote:
> > Use the COPY command.
>
> Someone said this command only accepts TAB delimited files, with no
> string delimiter. Is it possible to change these settings?

Have a look at:

http://www.postgresql.org/docs/user/sql-copy.htm

But, yes, you can change the delimiter using the 'DELIMITERS' clause.

HTH,

Neil

--
Neil Conway <neilconway(at)home(dot)com>
Get my GnuPG key from: http://klamath.dyndns.org/mykey.asc
Encrypted mail welcomed

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Timothy Covell 2000-09-21 02:30:34 Re: [GENERAL] Foreign Keys Help Delete!
Previous Message Fernando Lozano 2000-09-21 01:43:17 Re: import CVS file