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

Re: Storing Binary Large Objects

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pdxpug(at)postgresql(dot)org
Subject: Re: Storing Binary Large Objects
Date: 2007-03-29 01:31:16
Message-ID: Pine.LNX.4.64.0703281830170.11746@salmo.appl-ecosys.com (view raw or flat)
Thread:
Lists: pdxpug
On Wed, 28 Mar 2007, Mark Wong wrote:

> I believe the main difference is that one is a datatype the other is the
> name of the table's column of row id's.

   Oh. OK.

> So another difference between using oid and bytea is that to insert a
> large object into the database using the oid datatype requires the use of
> special large object functions.  You can't simply insert escaped data,
> while you can with a bytea datatype.

   So, to store .pdf files I'd use the oid data type, yes? I'll read up on
that.

Thanks,

Rich

-- 
Richard B. Shepard, Ph.D.               |    The Environmental Permitting
Applied Ecosystem Services, Inc.        |          Accelerator(TM)
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863

In response to

Responses

pdxpug by date

Next:From: David E. WheelerDate: 2007-03-29 03:54:49
Subject: Re: Storing Binary Large Objects
Previous:From: Mark WongDate: 2007-03-29 00:25:25
Subject: Re: Storing Binary Large Objects

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