CSV options in COPY

From: "hjenkins" <hjenkins(at)uvic(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: CSV options in COPY
Date: 2008-01-22 22:29:41
Message-ID: 4563.142.104.193.193.1201040981.squirrel@wm3.uvic.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello, all,

On the subject of the COPY command
(http://www.postgresql.org/docs/current/interactive/sql-copy.html) is it
the case that the HEADER, QUOTE, escape, FORCE QUOTE, and FORCE NOT NULL
options can only be used in CSV mode? If so, why? A tab-delimited table
with a header line and quoted strings seems a perfectly reasonable format.
If not, how?

Regards,
Hazel Jenkins

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2008-01-22 22:42:07 Re: CSV options in COPY
Previous Message Adam Rich 2008-01-22 20:26:44 Re: altering foreign keys