| From: | Frank Bax <fbax(at)sympatico(dot)ca> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: store pdf files |
| Date: | 2008-12-09 17:57:15 |
| Message-ID: | 493EB17B.4030601@sympatico.ca |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
ivan marchesini wrote:
> Hi to all...
> I need to create a db that contain link to some pdf files..
> At the moment these are simple links (to the files that are stored into
> the file system) storing paths into a column of a dbf table...
>
> I need to manage this data considering that the db I'm going to create
> will be moved in some months to another server...
> so I think that the link to the files positions into the file system
> isn't a valid solution...
>
> can you suggest me a better way to manage this pdf data??
> Each pdf is quite small (<100k)
>
> should I use BLOB?
Leave the files on filesystem and code the highest level directory into
a function.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2008-12-09 18:02:10 | Re: inconsistent automatic casting between psql and function |
| Previous Message | Stefano Buliani | 2008-12-09 17:28:21 | inconsistent automatic casting between psql and function |