I am using postgresql 8.0 beta 4 on win2000.
psql operates strangely within a cmd.exe window. It is somewhat like if
you backgrounded the command in unix. with psql in interactive mode (no
-f switch) whatever line you type is alternately processed by cmd.exe and
psql.
So you get the following (
It seems the psql \copy command doesn't work properly when dealing
with certain non-ascii characters (which ones I don't know). At any rate
I took some binary data and escaped it like so with perl.
$text=~s/\\//g;
$text=~s/\n/\\\n/g;
$text=~s/\t/\\\t/g;
In other words I escaped escape chara
I wrote:
> It seems the psql \copy command doesn't work properly when dealing
> with certain non-ascii characters (which ones I don't know). At any rate
> I took some binary data and escaped it like so with perl.
I was wrong. I wasn't escaping things properly; in particular,
ascii 0 needed to be
Sorry for the duplicate post. I forgot to mention this is with
Postgresql 7.2.2.
It seems the psql \copy command doesn't work properly when dealing
with certain non-ascii characters (which ones I don't know). At any rate
I took some binary data and escaped it like so with perl.
$text=~s/\\/
