Re: how to read bytea field - Mailing list pgsql-general

marcelo Cortez wrote:
> folks
>
>
>  my table
>
> CREATE TABLE pblfield
> (
>   id_ integer NOT NULL,
>   value_field bytea,
>   name character varying(128),
>   osset integer,
>   length integer,
>   version_ integer,
>   inst_class_ character varying(128),
>   CONSTRAINT pblfield_pkey PRIMARY KEY (id_)
> )
>
>  insert into pblfield( id_ , value_field ) values( 1 ,
> encode(E'\\000\\001', 'escape') ) ;

NO! Go back and read what everyone is saying about the direction
decode/encode work in.

You're using them the wrong way around.

--
   Richard Huxton
   Archonet Ltd