BYTEA data type
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 mysql user}
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
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:
Show quoted text
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 mysql user}
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
Unfortunately, 7.2 (current development) version docs are not online...
In what sense are they not on line?
The docs are rebuilt twice a day and posted on the developer's web page,
but I see that they are labeled "Developer's Guide" rather than "The
Development Docs" or somesuch.
Vince, could we make the label a bit clearer? What would you suggest?
- Thomas
On Mon, 16 Jul 2001, Thomas Lockhart wrote:
Unfortunately, 7.2 (current development) version docs are not online...
In what sense are they not on line?
The docs are rebuilt twice a day and posted on the developer's web page,
but I see that they are labeled "Developer's Guide" rather than "The
Development Docs" or somesuch.Vince, could we make the label a bit clearer? What would you suggest?
- Thomas
fixed.
--
==========================================================================
Vince Vielhaber -- KA8CSH email: vev@michvhf.com http://www.pop4.net
56K Nationwide Dialup from $16.00/mo at Pop4 Networking
Online Campground Directory http://www.camping-usa.com
Online Giftshop Superstore http://www.cloudninegifts.com
==========================================================================