Thread: 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: > 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 >
> 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 ==========================================================================