Re: Storing large files in multiple schemas: BLOB or BYTEA
John DeSoi <[email protected]> Thu, 11 Oct 2012 09:05:25 -0400
| Newsgroups | gmane.comp.db.postgresql.php |
|---|---|
| Message-ID | <[email protected]> |
On Oct 10, 2012, at 6:12 AM, [email protected] wrote: > 2. BYTEA. These are correctly stored per schema so pg_dump =96n works cor= rectly however I cannot seem to find a way to stream the data. This means t= hat 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 la= rge columns in chunks. See http://www.postgresql.org/docs/current/interactive/functions-binarystring.h= tml John DeSoi, Ph.D. --=20 Sent via pgsql-php mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-php