>
> Hi All,
> Is their any way to read the bytea contents by using pgsql script.
>
> Thanks & regards
> Vijay
>
> _________________________________________________________________
>
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.
HTH
Regards, Christoph