Re: [SQL] Blobs

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Neil Cameron <n(dot)cameron(at)blueice(dot)co(dot)uk>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: [SQL] Blobs
Date: 2000-01-24 23:49:17
Message-ID: Pine.LNX.4.21.0001242123140.525-100000@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

You have to use "large objects". See the programmer's guide.

On 2000-01-24, Neil Cameron mentioned:

> Hi Folks
>
> I want to store Word docs etc into the mighty Postgres. I think this means using blobs.
>
> 1.Does anybody know the SQL to create say a table with a field called docs to store them in. I don't know what the data type is.
>
> ie something like CREATE TABLE documents docs (blob datatype ??)
>
> 2. Is there some special syntax to get the blob back. ie SELECT (special syntax)
>
> Thanks
>
> Neil(at)blueice
>
>

--
Peter Eisentraut Sernanders väg 10:115
peter_e(at)gmx(dot)net 75262 Uppsala
http://yi.org/peter-e/ Sweden

In response to

  • Blobs at 2000-01-24 22:33:59 from Neil Cameron

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2000-01-25 01:50:15 DISTINCT ON: speak now or forever hold your peace
Previous Message Neil Cameron 2000-01-24 22:33:59 Blobs