Re: [PATCHES] allow CSV quote in NULL - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [PATCHES] allow CSV quote in NULL
Date
Msg-id 26707.1185902480@sss.pgh.pa.us
Whole thread Raw
In response to Re: [PATCHES] allow CSV quote in NULL  (Andrew Dunstan <andrew@dunslane.net>)
Responses Re: [PATCHES] allow CSV quote in NULL  (Stephen Frost <sfrost@snowman.net>)
List pgsql-hackers
Andrew Dunstan <andrew@dunslane.net> writes:
> ... Oh, and if we did allow the 
> quote char we should surely only allow it on input - just because other 
> programs produce absurd output there is not reason we should.

Yeah.  The *real* problem with the patch as proposed is that it allows a
COPY OUT to emit a file that cannot be reloaded correctly, even given
the same options used to prepare it.  I think that the restrictions were
put there more to prevent that scenario than to restrict COPY IN.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: stats_block_level
Next
From: Tom Lane
Date:
Subject: Re: stats_block_level