Re: Fwd: How to convert a string to bytea?

# revoohc(at)gmail(dot)com / 2006-08-30 12:22:47 -0400:
> ---------- Forwarded message ----------
> From: Chris Hoover <revoohc(at)gmail(dot)com>
> Date: Aug 30, 2006 12:22 PM
> Subject: How to convert a string to bytea?
> To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
>
> I am in need of some help. I need to use the encode function against a text
> string in one of my pg/plsql functions. However, the encode function
> expects a bytea field to be passed to it. How do I convert my text string
> into a bytea?

See decode()/encode() in
http://www.postgresql.org/docs/8.1/static/functions-binarystring.html

--
How many Vietnam vets does it take to screw in a light bulb?
You don't know, man. You don't KNOW.
Cause you weren't THERE. http://bash.org/?255991