Thread: Large binary objects?
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@embley.spc.uchicago.edu for public key A guiding voice for all humanity: http://www.yellow5.com/pokey/
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@embley.spc.uchicago.edu for public key > A guiding voice for all humanity: http://www.yellow5.com/pokey/
> "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, Have a look at "large objects", described in postgres_manual/lobj.html if you have installed the online manual. I have no personal experience with them, so can't speak to their efficiency or reliability. Bill