From: | Mark Versaggi <Mark(at)versaggi(dot)com> |
---|---|
To: | "Michael R(dot) Jinks" <mjinks(at)uchicago(dot)edu> |
Cc: | pgsql-novice(at)hub(dot)org |
Subject: | Re: Large binary objects? |
Date: | 2000-05-31 00:41:41 |
Message-ID: | 39345FC5.82E68295@versaggi.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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/
From | Date | Subject | |
---|---|---|---|
Next Message | Bill Morrow | 2000-05-31 01:57:55 | Re: Large binary objects? |
Previous Message | Michael R. Jinks | 2000-05-30 22:35:48 | Large binary objects? |