BYTEA data type

BYTEA data type

Post by Ben-Nes Nimro » Tue, 17 Jul 2001 04:02:36



This is a multi-part message in MIME format.

------=_NextPart_000_0018_01C10D78.072534C0
Content-Type: text/plain; charset="windows-1255"
Content-Transfer-Encoding: quoted-printable

Howdie
im trying to make a table which will hold information about files and i nee=
d 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 availab=
le at postgresql?
with thanks in advance
Yonatan Ben-Nes

------=_NextPart_000_0018_01C10D78.072534C0
Content-Type: text/html; charset="windows-1255"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Dwindows-1255" http-equiv=3DContent-Ty=
pe>
<META content=3D"MSHTML 5.00.2614.3500" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Howdie</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>im trying to make a table which will hold=
=20
information about files and i need to use the "blob" data type {im a former=
=20
mysql user}</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>now i understood that there is a better da=
ta type=20
which is called "bytea".</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>is it true?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>and y i cant find it at the manual? {and a=
lso at=20
pgaccess program}</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>and where (if exist) can i find the full l=
ist of=20
data types which r available at postgresql?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>with thanks in advance</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Yonatan Ben-Nes</FONT></DIV></BODY></HTML>

------=_NextPart_000_0018_01C10D78.072534C0--

 
 
 

BYTEA data type

Post by Alex Pilos » Tue, 17 Jul 2001 04:59:18


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.


> 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

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

 
 
 

BYTEA data type

Post by Thomas Lockha » Tue, 17 Jul 2001 14:25:22


Quote:> 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

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://www.postgresql.org/search.mpl

 
 
 

BYTEA data type

Post by Vince Vielhab » Tue, 17 Jul 2001 19:28:26



> > 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.

--
==========================================================================

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

---------------------------(end of broadcast)---------------------------