Re: storing PDFs

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 the
>file the database, but I would like to also store the actual file
>itself in a field for redundancy purposes and other business reasons.
>I am curious to know what everyone thinks would be the best way to
>store PDF files in postgres??
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>
>
>
>

You can use ByteA but the size will be about 4 times bigger
You can use varchar and encode to Base64 and wil be abour 30% bigger

Leonel