Re: [GENERAL] storing PDFs

2006-01-01 Thread Scott Ribe
> 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)

Re: [GENERAL] storing PDFs

2006-01-01 Thread Leonel Nunez
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

Re: [GENERAL] storing PDFs

2006-01-01 Thread Doug McNaught
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

Re: [GENERAL] storing PDFs

2006-01-01 Thread Leonel Nunez
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

Re: [GENERAL] storing PDFs

2006-01-01 Thread John DeSoi
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

Re: [GENERAL] storing PDFs

2006-01-01 Thread Larry Rosenman
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

Re: [GENERAL] storing PDFs

2006-01-01 Thread Michael Glaesemann
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)-

[GENERAL] storing PDFs

2006-01-01 Thread littlebutty
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,