I'm a novice so this may not be just right, but I don't think you can store
binary stuff into a database.
What I did with files and descriptive data wat to upload the files seperatly and
use the database to hold all the descriptive info.
For example. I have fields 1 tru 10 each with descriptive info in them. Field 10
holds the name of the file I am refering to. Then I created an html page that
took all the info and placed it into a useable format. I linked the file name
from field 10 to the actual upload directory containing the true bianary file.
It's my creative way of doing things.
"Michael R. Jinks" wrote:
> I've been asked to look into setting up a database for storing audio footage
> with accompanying descriptive data, but as I look at the PostgreSQL specs
> I don't find a "binary" data type. Is that because this sort of thing can't
> be done with PostgreSQL, or because I'm looking at it the wrong way?
> Michael Jinks, IB
> Systems Administrator, Chicago Center for Computational Psychology
> finger mjinks(at)embley(dot)spc(dot)uchicago(dot)edu for public key
> A guiding voice for all humanity: http://www.yellow5.com/pokey/
In response to
pgsql-novice by date
|Next:||From: Bill Morrow||Date: 2000-05-31 01:57:55|
|Subject: Re: Large binary objects?|
|Previous:||From: Michael R. Jinks||Date: 2000-05-30 22:35:48|
|Subject: Large binary objects?|