Re: binary data types and streaming

Hi David!

If you need streaming access to binary data use PostgreSQL's "large
objects". They provide what you might want.

Greets


Dennis

> Hi-
>
> I'm looking for information about storing binary data in postgres.
> I've set up a few tests where in I stored bytea data, but I have a few
> other questions and I'm wondering if postgres will meet my needs.
> Just to start off, here's a couple of questions:
>
>    What are the differences between using the bytea type and the BLOB
> type?
>
>    Is there any type of streaming support built into postgres' binary
> datatype handling?  For instance, can I specify a beginning offset for
> the binary data that I want>
>
>
> I didn't see a whole lot of information about this topic in the
> postgres 8.1 manual.  Can anyone point me to documentation on this
> subject or refer me to a book?  Thanks,
>
>
> Dave
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend