Skip site navigation (1) Skip section navigation (2)

SQL repr of bytea val

From: Markus Bertheau ☭ <twanger(at)bluetwanger(dot)de>
To: pgsql-sql(at)postgresql(dot)org
Subject: SQL repr of bytea val
Date: 2005-06-20 13:47:01
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-sql

I'm constructing querys on the fly in PL/pgSQL_ and need a function that
returns the SQL representation of a bytea value. I tried encode(..,
'escape') but it seems to return 8 bit ASCII values, not the \377 stuff
that's supposed to be in the bytea input syntax. Does anyone know a way
to do that?


Markus Bertheau ☭ <twanger(at)bluetwanger(dot)de>


pgsql-sql by date

Next:From: gruposDate: 2005-06-20 16:31:20
Subject: Array in plpgsql with composite type
Previous:From: Theodore PetroskyDate: 2005-06-20 12:29:03
Subject: Re: info

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group