From: Stephan Szabo <sszabo@megazone23.bigpanda.com>
To: Radu-Adrian Popescu <radu.popescu@www.aldratech.com>
Cc: csawtell@paradise.net.nz
Cc: pgsql-sql@postgresql.org
Subject: Re: How to use BYTEA type?
Date: Thu, 1 Nov 2001 08:22:51 -0800 (PST)
Message-ID: <20011101081044.G22509-100000@megazone23.bigpanda.com> (raw)
In-Reply-To: <3BE120D1.3060406@www.aldratech.com>
On Thu, 1 Nov 2001, Radu-Adrian Popescu wrote:
> Doing
>
> template1=> SELECT proname from pg_proc ;
> proname
> ------------------------
> boolin
> boolout
> byteain
> byteaout
>
> you can see there is a byteaout function also. However, these are
> undocumented in the interactive docs, which is a shame indeed. I only
> learned of byteain/out after reading your email.
>
> If some of the postgresql guys could point the location of the
> documentation of undocumented functions :-) that'd be great.
AFAIK, the in and out functions are *not* meant to be called by
users. They're used by the system and I think they technically
take pointer values. To use bytea correctly, I believe you are
supposed to do some escaping and place the value into the
insert statement.
insert into table values ('\011\005\\000afkajdd\011');
(note the double backslash on the null byte). And you should
get the value back from a straight select on the column I believe.
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-sql@postgresql.org
Cc: sszabo@megazone23.bigpanda.com, radu.popescu@www.aldratech.com, csawtell@paradise.net.nz
Subject: Re: How to use BYTEA type?
In-Reply-To: <20011101081044.G22509-100000@megazone23.bigpanda.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