Re: [GENERAL] CSV options in COPY

2008-01-22 Thread Tom Lane
"hjenkins" <[EMAIL PROTECTED]> 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 tabl

[GENERAL] CSV options in COPY

2008-01-22 Thread hjenkins
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 st