Re: How to cast VARCHAR to BYTEA and vice-versa?

From: Ragnar Hafstað <gnari(at)simnet(dot)is>
To: "Moran(dot)Michael" <Michael(dot)Moran(at)IGT(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: How to cast VARCHAR to BYTEA and vice-versa?
Date: 2005-03-14 08:46:33
Message-ID: 1110789993.12425.16.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Tue, 2005-03-08 at 07:31 -0800, Moran.Michael wrote:
> Hello all,
>
> I have a table with a VARCHAR column that I need to convert to a BYTEA.
>
> How do I cast VARCHAR to BYTEA?

have you looked at the encode() and decode() functions ?
http://www.postgresql.org/docs/7.4/interactive/functions-string.html

gnari

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message PFC 2005-03-14 08:58:10 Re: group by before and after date
Previous Message Richard Huxton 2005-03-14 08:20:42 Re: finding schema of table that called a trigger