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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | David E. Wheeler | 2007-03-29 03:54:49 | Re: Storing Binary Large Objects |
Previous Message | Mark Wong | 2007-03-29 00:25:25 | Re: Storing Binary Large Objects |