Skip site navigation (1) Skip section navigation (2)

Re: bytea on windows perl client

From: Jeremy Buchmann <jeremy(at)wellsgaming(dot)com>
To: James Orr <james(at)lrgmail(dot)com>
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: bytea on windows perl client
Date: 2002-07-17 17:17:55
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-interfaces
On Wednesday, July 17, 2002, at 10:06 AM, Joe Conway wrote:

> 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


This may be a long shot, but try to binmode your output stream:

Let us know how it works.


In response to


pgsql-interfaces by date

Next:From: James OrrDate: 2002-07-17 17:37:16
Subject: Re: bytea on windows perl client
Previous:From: Joe ConwayDate: 2002-07-17 17:06:09
Subject: Re: bytea on windows perl client

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group