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
In response to
Responses
pgsql-hackers by date
| Next: | From: Christopher Kings-Lynne | Date: 2005-06-02 03:24:03 |
| Subject: SELECT FOR UPDATE and UNION ALL |
| Previous: | From: Luke Lonergan | Date: 2005-06-02 02:40:06 |
| Subject: Re: NOLOGGING option, or ? |