Postgres Pro
Downloads
Home   >   mailing lists

Re: How to cast VARCHAR to BYTEA and vice-versa? - Mailing list pgsql-sql

From Ragnar Hafstað
Subject Re: How to cast VARCHAR to BYTEA and vice-versa?
Date
Msg-id 1110789993.12425.16.camel@localhost.localdomain
Whole thread Raw
In response to How to cast VARCHAR to BYTEA and vice-versa?  ("Moran.Michael" <Michael.Moran@IGT.com>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Richard Huxton
Date:
Subject: Re: finding schema of table that called a trigger
Next
From: PFC
Date:
Subject: Re: group by before and after date