Re: COPY formatting

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: COPY formatting
Date: 2004-03-19 15:49:30
Message-ID: 24654.1079711370@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Karel Zak <zakkr(at)zf(dot)jcu(dot)cz> writes:
> And what \n in attibutes data in CSV? I think CSV format doesn't use
> some escape for newline char. It means psql with \copy cannot be sure
> with CSV.

I think CSV only allows embedded newlines that are either escaped, or
inside quotes. COPY doesn't currently have the notion of a quote
character, but that was part of Andrew's proposal ...

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2004-03-19 15:55:53 Re: [HACKERS] UnixWare/CVS Tip/initdb.c needs to use threads
Previous Message Larry Rosenman 2004-03-19 15:47:57 Re: [HACKERS] UnixWare/CVS Tip/initdb.c needs to use