pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedbinary 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>
2006-02-21 21:31 ` Re: binary data types and streaming Peter Eisentraut <peter_e@gmx.net>
2006-02-22 08:57 ` Re: binary data types and streaming Dennis Wagner <wagner@Spheron.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 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 ` Re: binary data types and streaming 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 20:57 binary data types and streaming David Durham <ddurham@vailsys.com>
2006-02-21 21:31 ` Re: binary data types and streaming Peter Eisentraut <peter_e@gmx.net>
@ 2006-02-21 23:43 ` David Durham <ddurham@vailsys.com>
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-21 20:57 binary data types and streaming David Durham <ddurham@vailsys.com>
@ 2006-02-22 08:57 ` Dennis Wagner <wagner@Spheron.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