pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
binary data types and streaming
4+ messages / 3 participants
[nested] [flat]

* binary data types and streaming
@ 2006-02-21 20:57  David Durham <ddurham@vailsys.com>
  0 siblings, 2 replies; 4+ messages in thread

From: David Durham @ 2006-02-21 20:57 UTC (permalink / raw)
  To: pgsql-admin

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



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: binary data types and streaming
@ 2006-02-21 21:31  Peter Eisentraut <peter_e@gmx.net>
  parent: David Durham <ddurham@vailsys.com>
  1 sibling, 1 reply; 4+ messages in thread

From: Peter Eisentraut @ 2006-02-21 21:31 UTC (permalink / raw)
  To: pgsql-admin; +Cc: David Durham <ddurham@vailsys.com>

David Durham wrote:
>     What are the differences between using the bytea type and the
> BLOB type?

The bytea type exists, the blob type does not.

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

substring and other such functions are available.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: binary data types and streaming
@ 2006-02-21 23:43  David Durham <ddurham@vailsys.com>
  parent: Peter Eisentraut <peter_e@gmx.net>
  0 siblings, 0 replies; 4+ messages in thread

From: David Durham @ 2006-02-21 23:43 UTC (permalink / raw)
  To: Peter Eisentraut <peter_e@gmx.net>; +Cc: pgsql-admin

Peter Eisentraut wrote:
>>    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
> 
> substring and other such functions are available.

Thanks.  I didn't realize that string functions could be used on bytea 
columns.


-Dave



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: binary data types and streaming
@ 2006-02-22 08:57  Dennis Wagner <wagner@Spheron.com>
  parent: David Durham <ddurham@vailsys.com>
  1 sibling, 0 replies; 4+ messages in thread

From: Dennis Wagner @ 2006-02-22 08:57 UTC (permalink / raw)
  To: pgsql-admin

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





^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2006-02-22 08:57 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-02-21 20:57 binary data types and streaming David Durham <ddurham@vailsys.com>
2006-02-21 21:31 ` Peter Eisentraut <peter_e@gmx.net>
2006-02-21 23:43   ` David Durham <ddurham@vailsys.com>
2006-02-22 08:57 ` Dennis Wagner <wagner@Spheron.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox