Skip site navigation (1) Skip section navigation (2)

Re: Storing large files in multiple schemas: BLOB or BYTEA

From: John DeSoi <desoi(at)pgedit(dot)com>
To:
Cc: <pgsql-php(at)postgresql(dot)org>
Subject: Re: Storing large files in multiple schemas: BLOB or BYTEA
Date: 2012-10-11 13:05:25
Message-ID: EBDC2605-CAF2-4403-B9E5-14199ABB78F1@pgedit.com (view raw or flat)
Thread:
Lists: pgsql-php
On Oct 10, 2012, at 6:12 AM, tigran2-postgres(at)riatest(dot)com wrote:

> 2. BYTEA. These are correctly stored per schema so pg_dump –n 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.



In response to

pgsql-php by date

Next:From: David McMathDate: 2012-11-19 16:45:49
Subject: How to specify capitalization for column names in pg_fetch_object?
Previous:From: John DeSoiDate: 2012-10-11 12:59:13
Subject: Re: Storing large files in multiple schemas: BLOB or BYTEA

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group