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 9A67E9DCB4C for ; Wed, 22 Feb 2006 05:00:48 -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 59690-08 for ; Wed, 22 Feb 2006 05:00:49 -0400 (AST) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 8A50A9DCADB for ; Wed, 22 Feb 2006 05:00:46 -0400 (AST) Received: from 115.N1.EF.nwx-server.de (115.N1.EF.nwx-server.de [217.114.219.115]) by svr4.postgresql.org (Postfix) with ESMTP id 22E195AF062 for ; Wed, 22 Feb 2006 09:00:47 +0000 (GMT) Received: from spheron.com (Eaa03.ex.pppool.de [194.97.170.3]) by 115.N1.EF.nwx-server.de (Postfix) with ESMTP id C3522270137 for ; Wed, 22 Feb 2006 10:00:40 +0100 (CET) DomainKey-Signature: a=rsa-sha1; s=MDaemon; d=spheron.com; c=simple; q=dns; h=from:message-id; b=trMRlbFK1bFIaAGDGjKKmocBu2QuKKljgZ2PjlPynHuuedqyCZtlhmoQVnMtw1m3SQ7BopLrpoihYMY1nn1Ih5ozK8u85vUX9jJpOSSZprEErdIucFPKLOZIYDE75XihZrZ7/Ot+1IXb+9GLhtdfy5JUeuoUugPziW+MBDIIJhQ=; Received: from [127.0.0.1] by spheron.com (MDaemon.PRO.v8.1.4.R) with ESMTP id md50000418566.msg for ; Wed, 22 Feb 2006 10:00:18 +0100 Message-ID: <43FC276E.6090509@Spheron.com> Date: Wed, 22 Feb 2006 09:57:18 +0100 From: Dennis Wagner Organization: SpheronVR AG User-Agent: Thunderbird 1.5 (Windows/20051201) MIME-Version: 1.0 To: PostgreSQL-Admin Mailingliste Subject: Re: binary data types and streaming References: <43FB7EA2.8080003@vailsys.com> In-Reply-To: <43FB7EA2.8080003@vailsys.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Authenticated-Sender: wagner@spheron.com X-Spam-Processed: spheron.com, Wed, 22 Feb 2006 10:00:18 +0100 (not processed: message from valid local sender) X-MDRemoteIP: 192.168.0.60 X-Return-Path: wagner@Spheron.com X-MDaemon-Deliver-To: pgsql-admin@postgresql.org X-MDAV-Processed: spheron.com, Wed, 22 Feb 2006 10:00:20 +0100 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.351 required=5 tests=[AWL=0.351] X-Spam-Score: 0.351 X-Spam-Level: X-Archive-Number: 200602/250 X-Sequence-Number: 20671 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