Re: how to read bytea contents by using pgsql scripts - Mailing list pgsql-sql

> 
> 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