Re: Large binary objects?

Michael...

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.

Mark Versaggi

"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?
>
> TIA,
> -m
> --
> 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/