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)
Peter Eisentraut Sernanders väg 10:115
peter_e(at)gmx(dot)net 75262 Uppsala
In response to
- Blobs at 2000-01-24 22:33:59 from Neil Cameron
pgsql-sql by date
|Next:||From: Tom Lane||Date: 2000-01-25 01:50:15|
|Subject: DISTINCT ON: speak now or forever hold your peace|
|Previous:||From: Neil Cameron||Date: 2000-01-24 22:33:59|