Received: from serv0.ilse.net (serv0.ilse.nl [194.158.182.236])
	by hub.org (8.9.3/8.9.3) with ESMTP id KAA38917
	for <pgsql-sql@postgreSQL.org>; Mon, 24 Jan 2000 10:54:43 -0500 (EST)
	(envelope-from mathijs@ilse.nl)
Received: (from mathijs@localhost) by serv0.ilse.net (8.8.8/8.6.12) id
	QAA01705; Mon, 24 Jan 2000 16:54:40 +0100 (MET)
Date: Mon, 24 Jan 2000 16:54:39 +0100
From: Mathijs Brands <mathijs@ilse.nl>
To: Neil Cameron <n.cameron@blueice.co.uk>
Cc: pgsql-sql@postgreSQL.org
Subject: Re: [SQL] Blobs
Message-ID: <20000124165439.A1694@ilse.nl>
References: <011a01bf66bb$2483d400$03c6c6c6@leckhampton>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
X-Mailer: Mutt 1.0i
In-Reply-To: <011a01bf66bb$2483d400$03c6c6c6@leckhampton>;
	from n.cameron@blueice.co.uk on Mon, Jan 24, 2000 at 02:33:59PM
	-0800
X-Unexpected-Header: The Spanish Inquisition

On Mon, Jan 24, 2000 at 02:33:59PM -0800, Neil Cameron allegedly wrote:
> 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@blueice

You'll need to use large objects. The documentation explains how to (I'm
a bit lazy ;)

Mathijs