> Hi All,
> Is their any way to read the bytea contents by using pgsql script.
> Thanks & regards
Not sure if that's what you are asking for but you can do e.g.
$PGSQLD/bin/psql -d <your-dbase-name> -f ./query2.txt > ./query2.res
./query2.txt has something like
select * from bytea_tab ;
then you'll find all non-printables in ./query2.res
properly escaped as octets as shown in Data Types - Binary Strings.
In response to
pgsql-sql by date
|Next:||From: vijaykumar M||Date: 2003-11-24 12:47:42|
|Subject: Re: how to read bytea contents by using pgsql scripts|
|Previous:||From: Matthew Lunnon||Date: 2003-11-24 09:21:39|
|Subject: Re: increment int value in subset of rows?|