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 thir

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