X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id C3FFE9DCA67 for ; Tue, 21 Feb 2006 17:14:41 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 49554-10-3 for ; Tue, 21 Feb 2006 17:14:42 -0400 (AST) X-Greylist: delayed 00:17:33.909492 by SQLgrey- Received: from chrobd01.vailsys.com (chrobd01.vailsys.com [63.210.102.138]) by postgresql.org (Postfix) with ESMTP id 8C3139DCBC4 for ; Tue, 21 Feb 2006 17:14:39 -0400 (AST) Received: from dfsfbd06.vail (dfsfbd06.vail [192.168.129.190]) by chrobd01.vailsys.com (Postfix) with ESMTP id CE123497A for ; Tue, 21 Feb 2006 14:57:06 -0600 (CST) Received: from [192.168.129.15] (ltwddurham.vail [192.168.129.15]) by dfsfbd06.vail (Postfix) with ESMTP id AF3B4323FB3 for ; Tue, 21 Feb 2006 14:57:06 -0600 (CST) Message-ID: <43FB7EA2.8080003@vailsys.com> Date: Tue, 21 Feb 2006 14:57:06 -0600 From: David Durham User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: binary data types and streaming Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200602/245 X-Sequence-Number: 20666 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