> but If the bytea is encoded only for dump and load
I think that's the case, as with all binary types dump (consider numbers for
instance) to an ASCII encoding.
--
Scott Ribe
[EMAIL PROTECTED]
http://www.killerbytes.com/
(303) 665-7007 voice
---(end of broadcast)
Doug McNaught wrote:
Leonel Nunez <[EMAIL PROTECTED]> writes:
You can use ByteA but the size will be about 4 times bigger
Are you sure? The intermediate form for bytea (escaped single-quoted
strings) is pretty inefficient, but once in the database the data is
stored as binary a
Leonel Nunez <[EMAIL PROTECTED]> writes:
> You can use ByteA but the size will be about 4 times bigger
Are you sure? The intermediate form for bytea (escaped single-quoted
strings) is pretty inefficient, but once in the database the data is
stored as binary and can even be compressed.
Plus
littlebutty wrote:
I have written software that will dynamically create PDF documents used
within my web application. Because each document is unique, I would
like to store the resultant PDF into a field of the DB. Currently I
just store the file to the server's hard drive and insert a path to
On Dec 29, 2005, at 5:45 PM, littlebutty wrote:
I have written software that will dynamically create PDF documents
used
within my web application. Because each document is unique, I would
like to store the resultant PDF into a field of the DB. Currently I
just store the file to the server's
Michael Glaesemann wrote:
> On Dec 29, 2005, at 16:45 , littlebutty wrote:
>
>> I am curious to know what everyone thinks would be the best way to
>> store PDF files in postgres??
>
> The BYTEA data type should do the trick.
I did exactly this for a DB I did for a former employer of mine.
Work
On Dec 29, 2005, at 16:45 , littlebutty wrote:
I am curious to know what everyone thinks would be the best way to
store PDF files in postgres??
The BYTEA data type should do the trick.
Michael Glaesemann
grzm myrealbox com
---(end of broadcast)-
I have written software that will dynamically create PDF documents used
within my web application. Because each document is unique, I would
like to store the resultant PDF into a field of the DB. Currently I
just store the file to the server's hard drive and insert a path to the
file the database,