Postgres Pro
Downloads
Home   >   mailing lists

Re: Storing large files in multiple schemas: BLOB or BYTEA - Mailing list pgsql-php

From John DeSoi
Subject Re: Storing large files in multiple schemas: BLOB or BYTEA
Date
Msg-id EBDC2605-CAF2-4403-B9E5-14199ABB78F1@pgedit.com
Whole thread Raw
In response to Storing large files in multiple schemas: BLOB or BYTEA  (<tigran2-postgres@riatest.com>)
List pgsql-php
Tree view 
On Oct 10, 2012, at 6:12 AM, tigran2-postgres@riatest.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
streamthe 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.

pgsql-php by date:

Previous
From:
Date:
Subject: Storing large files in multiple schemas: BLOB or BYTEA
Next
From: John DeSoi
Date:
Subject: Re: Storing large files in multiple schemas: BLOB or BYTEA