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@postgresql.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