Skip site navigation (1) Skip section navigation (2)

store pdf files

From: ivan marchesini <marchesini(at)unipg(dot)it>
To: pgsql-sql(at)postgresql(dot)org
Subject: store pdf files
Date: 2008-12-09 10:11:21
Message-ID: 1228817481.6489.12.camel@ivangeo (view raw or flat)
Thread:
Lists: pgsql-sql
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?

many thanks

Ivan






-- 
Ti prego di cercare di non inviarmi files .dwg, .doc, .xls, .ppt.
Preferisco formati liberi.
Please try to avoid to send me .dwg, .doc, .xls, .ppt files.
I prefer free formats.
http://it.wikipedia.org/wiki/Formato_aperto
http://en.wikipedia.org/wiki/Open_format

Ivan Marchesini
Department of Civil and Environmental Engineering
University of Perugia
Via G. Duranti 93/a 
06125
Perugia (Italy)
Socio fondatore GFOSS "Geospatial Free and Open Source Software" http://www.gfoss.it
e-mail: marchesini(at)unipg(dot)it
        ivan(dot)marchesini(at)gmail(dot)com
tel: +39(0)755853760
fax (university): +39(0)755853756
fax (home): +39(0)5782830887
jabber: geoivan73(at)jabber(dot)org


Responses

pgsql-sql by date

Next:From: Richard HuxtonDate: 2008-12-09 11:08:32
Subject: Re: DIVISION with Group By
Previous:From: Richard HuxtonDate: 2008-12-09 09:46:07
Subject: A DISTINCT problem removing duplicates

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group