| 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: | Whole Thread | Raw Message | 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? |