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.
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
pdxpug by date
|Next:||From: Roth, Gabrielle||Date: 2007-03-28 22:27:39|
|Subject: Re: ER Diagramming Tools?|
|Previous:||From: Rich Shepard||Date: 2007-03-27 00:27:01|
|Subject: ER Diagramming Tools?|