Re: CSV options in COPY - Mailing list pgsql-general

From Tom Lane
Subject Re: CSV options in COPY
Date
Msg-id 8973.1201041727@sss.pgh.pa.us
Whole thread Raw
In response to CSV options in COPY  ("hjenkins" <hjenkins@uvic.ca>)
List pgsql-general
"hjenkins" <hjenkins@uvic.ca> writes:
> 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?

So set the CSV delimiter to TAB, if that's what you want.

            regards, tom lane

pgsql-general by date:

Previous
From: "hjenkins"
Date:
Subject: CSV options in COPY
Next
From: "Jamiil Abduqadir"
Date:
Subject: Installing PGSQL