From: | Rich Shepard <rshepard(at)appl-ecosys(dot)com> |
---|---|
To: | pdxpug(at)postgresql(dot)org |
Subject: | Storing Binary Large Objects |
Date: | 2007-03-28 22:05:14 |
Message-ID: | Pine.LNX.4.64.0703281501360.11746@salmo.appl-ecosys.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pdxpug |
I've not before needed to store BLOBs in a database, but now I do.
Specifically, I need to store scanned pages as .pdf files within a table.
Looking at the 8.2 docs I see there is a bytea data type that references
the SQL standard of blob (different input format, same functions and
operators). Is bytea the data type I want to use? If so, are there any
special considerations to storing and retrieving those files?
Pointers to more specific docs would be helpful.
Rich
--
Richard B. Shepard, Ph.D. | The Environmental Permitting
Applied Ecosystem Services, Inc. | Accelerator(TM)
<http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863
From | Date | Subject | |
---|---|---|---|
Next Message | Roth, Gabrielle | 2007-03-28 22:27:39 | Re: ER Diagramming Tools? |
Previous Message | Rich Shepard | 2007-03-27 00:27:01 | ER Diagramming Tools? |