Re: Function to convert from TEXT to BYTEA? - Mailing list pgsql-general

From TJ O'Donnell
Subject Re: Function to convert from TEXT to BYTEA?
Date
Msg-id 476024F2.1070907@acm.org
Whole thread Raw
In response to Function to convert from TEXT to BYTEA?  ("D. Dante Lorenso" <dante@lorenso.com>)
List pgsql-general
I think decode('your string', 'escape') might be what you need.
It returns bytea when 'your string' is type text or varchar.

TJ
http://www.gnova.com

> Is there a function that will do what I want to convert the datatype
> without having to create a CAST that PostgreSQL doesn't have natively?
> How else are you supposed to use the ENCRYPT and DECRYPT functions?


pgsql-general by date:

Previous
From: Jeff Trout
Date:
Subject: Re: Slow PITR restore
Next
From: Samantha Atkins
Date:
Subject: Re: what is the date format in binary query results