Received: from magus.postgresql.org ([87.238.57.229]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TMIMD-0007JT-6K for pgsql-php@postgresql.org; Thu, 11 Oct 2012 12:59:21 +0000 Received: from mail-yh0-f46.google.com ([209.85.213.46]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TMIM9-0007hm-CD for pgsql-php@postgresql.org; Thu, 11 Oct 2012 12:59:20 +0000 Received: by mail-yh0-f46.google.com with SMTP id m54so440297yhm.19 for ; Thu, 11 Oct 2012 05:59:16 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=content-type:mime-version:subject:from:in-reply-to:date:cc :content-transfer-encoding:message-id:references:to:x-mailer; bh=WpFN8z5VoEWXZRJDbdPlIskEFyk9OyP3X8xFx2jIvf4=; b=Q313PlOtZMcAqWmystsEamuNsAC8ChxV1q3gtyEdvcTPSSzRa0Z7y7F+fFPhKj/dDZ 2Ym4qWguRE+PgD0KVDLVKZKvmY6HJSqSDgbyPJuYhWzqwdp5/s/pMh+lvlpnBbLHGY7+ gLAVr9z9dKvjFDayRigpHS1fxgHjNvKWpt2HyRDtlhs5HesNJyJWDlkioRVWZ7N5p/17 Rq1QHAe5IfDWkLiI+uuJDbefNYnGWAIxkZKnhoQIZibr0k364MhGSta/OjEzibwGxDdr M81SyeD34cni4Y1f7FTVtJ6Iviga1A9YD8frLmnfjJsuJABFwwUby6c+blU7KxjwgrUU RUDg== Received: by 10.236.118.17 with SMTP id k17mr643612yhh.69.1349960356077; Thu, 11 Oct 2012 05:59:16 -0700 (PDT) Received: from [10.0.0.22] (adsl-98-70-101-237.tys.bellsouth.net. [98.70.101.237]) by mx.google.com with ESMTPS id o12sm3666386anp.8.2012.10.11.05.59.15 (version=SSLv3 cipher=OTHER); Thu, 11 Oct 2012 05:59:15 -0700 (PDT) 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 08:59:13 -0400 Cc: Content-Transfer-Encoding: quoted-printable Message-Id: References: <006d01cda6cf$b5e642e0$21b2c8a0$@riatest.com> To: tigran2-postgres@riatest.com X-Mailer: Apple Mail (2.1498) X-Pg-Spam-Score: -2.7 (--) X-Archive-Number: 201210/5 X-Sequence-Number: 4282 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.