Received: from neptune.wyenet.net (neptune.wyenet.net [195.188.115.3]) by hub.org (8.9.3/8.9.3) with ESMTP id JAA22277 for ; Mon, 24 Jan 2000 09:50:02 -0500 (EST) (envelope-from n.cameron@blueice.co.uk) Received: from leckhampton ([195.188.115.222]) by neptune.wyenet.net (Post.Office MTA v3.5.2 release 221 ID# 527-57157U1000L100S0V35) with SMTP id net for ; Mon, 24 Jan 2000 14:49:37 +0000 Message-ID: <011a01bf66bb$2483d400$03c6c6c6@leckhampton> From: "Neil Cameron" To: Subject: Blobs Date: Mon, 24 Jan 2000 14:33:59 -0800 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0117_01BF6678.0DD477C0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 4.72.3110.1 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 This is a multi-part message in MIME format. ------=_NextPart_000_0117_01BF6678.0DD477C0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi Folks I want to store Word docs etc into the mighty Postgres. I think this = means using blobs.=20 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 ------=_NextPart_000_0117_01BF6678.0DD477C0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi Folks
 
I want to store Word docs etc into = the mighty=20 Postgres. I think this means using blobs.
 
1.Does anybody know the SQL to = create say a=20 table with a field called docs to store them in. I don't know what the = data type=20 is.
 
    ie something like = CREATE=20 TABLE documents docs (blob datatype ??)
 
2. Is there some special syntax to = get the blob=20 back. ie SELECT (special syntax)
 
Thanks
 
Neil@blueice
 
------=_NextPart_000_0117_01BF6678.0DD477C0--