Thread: BYTEA data type

BYTEA data type

From
"Ben-Nes Nimrod"
Date:
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

Re: BYTEA data type

From
Alex Pilosov
Date:
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
>


Re: BYTEA data type

From
Thomas Lockhart
Date:
> 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

Re: BYTEA data type

From
Vince Vielhaber
Date:
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
==========================================================================