Re: CSV options in COPY

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "hjenkins" <hjenkins(at)uvic(dot)ca>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: CSV options in COPY
Date: 2008-01-22 22:42:07
Message-ID: 8973.1201041727@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"hjenkins" <hjenkins(at)uvic(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jamiil Abduqadir 2008-01-23 00:46:42 Installing PGSQL
Previous Message hjenkins 2008-01-22 22:29:41 CSV options in COPY