Re: how to read bytea field

marcelo Cortez wrote:
>> Are you sure you tested with a real bytea field?
>
> Yeah , i store bytea using encode function , how you
> say .

No, you store using the decode function.

=> \df decode
List of functions
Schema | Name | Result data type | Argument data types
------------+--------+------------------+---------------------
pg_catalog | decode | bytea | text, text

> The field of my table is bytea type , and store real
> bytea data in this field.
> My problem is , i can't convert this field to text
> anymore, not function receiving bytea and return text
> exist's.

That's what your encode function should do.

=> \df encode
List of functions
Schema | Name | Result data type | Argument data types
------------+--------+------------------+---------------------
pg_catalog | encode | text | bytea, text
(1 row)

What does "\df encode" show for you?
--
Richard Huxton
Archonet Ltd