Re: storing PDFs - Mailing list pgsql-general

From Leonel Nunez
Subject Re: storing PDFs
Date
Msg-id 43B7F97E.1010803@enelserver.com
Whole thread Raw
In response to storing PDFs  ("littlebutty" <littlebutty@gmail.com>)
Responses Re: storing PDFs
List pgsql-general
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


pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: 8.1 removed functions
Next
From: Doug McNaught
Date:
Subject: Re: storing PDFs