> > Yes, this opens a good question. We have long text fields, and bytea for
> > binary input with escapes. As far as I know, we can store binary values
> > in text fields, but we have no way of getting them in there via SQL
> > queries (except for bytea using escapes for the binary values).
>
> "bytea for binary data with escapes"??
>
> What would those escapes look like? I could not find any escape
> that would put a NULL character into a bytea field.
'a\\0b' put a, NULL, b. You need double-backslash to get one backslash
to the backend.
--
Bruce Momjian | http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
