Re: store pdf files - Mailing list pgsql-sql

From Frank Bax
Subject Re: store pdf files
Date
Msg-id 493EB17B.4030601@sympatico.ca
Whole thread Raw
In response to store pdf files  (ivan marchesini <marchesini@unipg.it>)
Responses Re: store pdf files
List 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.


pgsql-sql by date:

Previous
From: "Stefano Buliani"
Date:
Subject: inconsistent automatic casting between psql and function
Next
From: Richard Huxton
Date:
Subject: Re: inconsistent automatic casting between psql and function