From: Joe Conway <mail@joeconway.com>
To: James Orr <james@lrgmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: bytea on windows perl client
Date: Wed, 17 Jul 2002 10:06:09 -0700
Message-ID: <3D35A401.1090301@joeconway.com> (raw)
References: <200207171201.25600.james@lrgmail.com>
<14471.1026922139@sss.pgh.pa.us>
<200207171300.01423.james@lrgmail.com>
James Orr wrote:
> OK, if I load the output into vi. The one from linux contains a
bunch > of control characters etc. The one from windows seems to be all
text
> like so
> ...
>
> \211PNG\015\012\000 and so on.
This is the escaped output form of bytea. It seems that on linux the
perl script is either using a binary cursor, or automagically unescaping
the output, while on windows it isn't. I'm not sure why that would
happen, but hopefully one of the perl gurus hanging around will chime in.
Joe
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: mail@joeconway.com, james@lrgmail.com, tgl@sss.pgh.pa.us
Subject: Re: bytea on windows perl client
In-Reply-To: <3D35A401.1090301@joeconway.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox