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

Re: Large binary objects?

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 (view raw or flat)
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/


In response to

Responses

pgsql-novice by date

Next:From: Bill MorrowDate: 2000-05-31 01:57:55
Subject: Re: Large binary objects?
Previous:From: Michael R. JinksDate: 2000-05-30 22:35:48
Subject: Large binary objects?

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