Re: Good Delimiter for copy command - Mailing list pgsql-general

From Mark Roberts
Subject Re: Good Delimiter for copy command
Date
Msg-id 1234892835.11148.295.camel@localhost
Whole thread Raw
In response to Re: Good Delimiter for copy command  (Marco Colombo <pgsql@esiway.net>)
List pgsql-general
On Tue, 2009-02-17 at 17:17 +0100, Marco Colombo wrote:
>
> Which makes me wonder, does copy accept UTF-8 input? Is it possibile
> to use some unicode character which is unlikely to appear in the data
> set as delimiter? Something like U+FFFC.

I'm also not able to get unicode characters to copy in like that, but I
also haven't had any problems with data containing the *tab* character.
It seems to be properly escaped (see my other email in this thread) so
it doesn't seem to matter if it appears in the data stream.  The *only*
reason I see to switch from tab is if the receiving application requires
it in a different format.

-Mark


pgsql-general by date:

Previous
From: Sam Mason
Date:
Subject: Re: transfering tables into other schema
Next
From: David Fetter
Date:
Subject: Re: hi all