Re: Fwd: How to convert a string to bytea? - Mailing list pgsql-general

From Roman Neuhauser
Subject Re: Fwd: How to convert a string to bytea?
Date
Msg-id 20060830215650.GC70552@dagan.sigpipe.cz
Whole thread Raw
In response to Fwd: How to convert a string to bytea?  ("Chris Hoover" <revoohc@gmail.com>)
List pgsql-general
# revoohc@gmail.com / 2006-08-30 12:22:47 -0400:
> ---------- Forwarded message ----------
> From: Chris Hoover <revoohc@gmail.com>
> Date: Aug 30, 2006 12:22 PM
> Subject: How to convert a string to bytea?
> To: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.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

pgsql-general by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Status on Fedora Core Extras packaging
Next
From: Joe Conway
Date:
Subject: Re: Dblink and connections to MySQL?