Afaik, not possible, at least I couldn't get any \0s into bytea column
from psql nor from perl DBI interface. You need blobs if you want to store
data which contains embedded nulls. Or so I think.
-alex
On Sun, 19 Mar 2000, Radhesh Mohandas wrote:
> Hi,
> Can somebody give me an example of how to insert a byte array for
> example
> { 12, 24 , 0, 3 , '\' , 40 } into a column declared as type bytea.
> Statements in psql is what I am looking forward to know
>
> Cheers,
> Radhesh Mohandas
> ****************************************************************************
> Residence: # Office:
> 341,#B,Rosedale Ave. # Jolley 541, Computer
> Science Dept. St.Louis,MO 63112 # One Brookings Drive,Washington University,
> St.Louis,MO - 63130.
> phone : 314-862-1418 # 314-935-7543
> ****************************************************************************
> Wealth is beyond what an individual can produce ??!!
> ****************************************************************************
>
>
>
