Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TMISC-00026I-UJ for pgsql-php@postgresql.org; Thu, 11 Oct 2012 13:05:33 +0000 Received: from a2s36.a2hosting.com ([216.119.134.130]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TMISA-0000oo-KC for pgsql-php@postgresql.org; Thu, 11 Oct 2012 13:05:32 +0000 Received: from [98.70.101.237] (port=50973 helo=[10.0.0.22]) by a2s36.a2hosting.com with esmtpsa (TLSv1:AES128-SHA:128) (Exim 4.77) (envelope-from ) id 1TMIS7-003Mrx-Bl for pgsql-php@postgresql.org; Thu, 11 Oct 2012 09:05:27 -0400 Content-Type: text/plain; charset=windows-1252 Mime-Version: 1.0 (Mac OS X Mail 6.1 \(1498\)) Subject: Re: Storing large files in multiple schemas: BLOB or BYTEA From: John DeSoi In-Reply-To: <006d01cda6cf$b5e642e0$21b2c8a0$@riatest.com> Date: Thu, 11 Oct 2012 09:05:25 -0400 Cc: Content-Transfer-Encoding: quoted-printable Message-Id: References: <006d01cda6cf$b5e642e0$21b2c8a0$@riatest.com> X-Mailer: Apple Mail (2.1498) X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - a2s36.a2hosting.com X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - pgedit.com X-Pg-Spam-Score: 1.8 (+) X-Archive-Number: 201210/4 X-Sequence-Number: 4281 On Oct 10, 2012, at 6:12 AM, tigran2-postgres@riatest.com wrote: > 2. BYTEA. These are correctly stored per schema so pg_dump =96n works = correctly however I cannot seem to find a way to stream the data. This = means that there is no way to access the data from PHP if it is larger = than memory limit. You can get the octet length and then use the substring function to grab = large columns in chunks. See = http://www.postgresql.org/docs/current/interactive/functions-binarystring.= html John DeSoi, Ph.D.