Re: [ADMIN] binary data types and streaming

2006-02-22 Thread Dennis Wagner
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 ques

Re: [ADMIN] binary data types and streaming

2006-02-21 Thread David Durham
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 co

Re: [ADMIN] binary data types and streaming

2006-02-21 Thread Peter Eisentraut
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 t

[ADMIN] binary data types and streaming

2006-02-21 Thread David Durham
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 betwe