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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster