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
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 |