[SQL] BYTEA output presentation

2004-07-16 Thread Peter Wang
I output the BYTEA datatype for a table in our database. The BYTEA data look like /031/024/001/003?/022/. How can I use some PostgreSQL function to remove / when I use select statement ? What type of format is the BYTEA datatype? Can I output it to hexadecimal or octal format ? If you can,

Re: [SQL] BYTEA output presentation

2004-07-16 Thread Peter Eisentraut
Peter Wang wrote: The BYTEA data look like /031/024/001/003?/022/. How can I use some PostgreSQL function to remove / when I use select statement ? What type of format is the BYTEA datatype? Can I output it to hexadecimal or octal format ? If you can, how ? Or do you know any third party