Unfortunately, 7.2 (current development) version docs are not online, and
current relased version (7.1.2) doesn't have it documented.
Bytea just stores a chunk of data. The difference between bytea and blobs
is that you cannot manipulate small chunks of bytea data currently, entire
bytea data must be extracted. (If you have 1-G long string in a bytea
column, and you only need first 8K bytes, entire string must be retrieved
first). If that's not a problem for you, use bytea.
There are some rules on escaping of bytea data. Do a search on
http://fts.postgresql.org for 'bytea escaping' for details.
On Sun, 15 Jul 2001, Ben-Nes Nimrod wrote:
> Howdie
> im trying to make a table which will hold information about files and i need to use the "blob" data type {im a former
mysqluser}
> now i understood that there is a better data type which is called "bytea".
> is it true?
> and y i cant find it at the manual? {and also at pgaccess program}
> and where (if exist) can i find the full list of data types which r available at postgresql?
> with thanks in advance
> Yonatan Ben-Nes
>