Re: [SQL] Encoding bytea

2004-03-04 Thread Achilleus Mantzios
O kyrios Joe Conway egrapse stis Mar 3, 2004 : > Achilleus Mantzios wrote: > > > is there a way to encode a bytea in such a way that the resulting > > text stream be readily available (\\ escaped for unprintable chars) for > > usage in an insert statement? > > > > None of base64,hex,escape opti

Re: [SQL] Encoding bytea

2004-03-03 Thread Joe Conway
Achilleus Mantzios wrote: is there a way to encode a bytea in such a way that the resulting text stream be readily available (\\ escaped for unprintable chars) for usage in an insert statement? None of base64,hex,escape options in encode() seem to produce anything close. This is meant to be used

[SQL] Encoding bytea

2004-03-03 Thread Achilleus Mantzios
Hi, is there a way to encode a bytea in such a way that the resulting text stream be readily available (\\ escaped for unprintable chars) for usage in an insert statement? None of base64,hex,escape options in encode() seem to produce anything close. This is meant to be used with generating inser