Re: NOLOGGING option, or ?
Steve Atkins <steve@blighty.com>
From: Steve Atkins <steve@blighty.com>
To: pgsql-hackers@postgresql.org
Date: 2005-06-02T02:47:26Z
Lists: pgsql-hackers
On Wed, Jun 01, 2005 at 07:35:33PM -0700, Luke Lonergan wrote: > >> I propose an extended syntax to COPY with a change in semantics to remove > >> the default of "WITH ESCAPE '\'". > > > > Er, doesn't this break existing database dumps? > > Yes, one of the previously stated reasons to create another command for > loading data. > > Another possible approach is to keep the default, but allow the escape > processing to be turned off. I've been following this thread, and I'm a little confused. Could you possibly clarify what you mean, by providing a couple of lines of input as it would be formatted with escape processing turned off - containing a text field with an embedded newline and tab and a null field. Cheers, Steve