agora inbox for pgsql-sql@postgresql.org  

help / color / mirror / Atom feed

From: Neil Cameron <n.cameron@blueice.co.uk>
To: pgsql-sql@postgresql.org
Subject: Blobs
Date: Mon, 24 Jan 2000 14:33:59 -0800
Message-ID: <011a01bf66bb$2483d400$03c6c6c6@leckhampton> (raw)

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

view thread (20+ messages)  latest in thread

Message-ID: <011a01bf66bb$2483d400$03c6c6c6@leckhampton>
Permalink:  ../011a01bf66bb$2483d400$03c6c6c6@leckhampton/
Also on:    postgresql.org/message-id/011a01bf66bb$2483d400$03c6c6c6@leckhampton

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: n.cameron@blueice.co.uk
  Subject: Re: Blobs
  In-Reply-To: <011a01bf66bb$2483d400$03c6c6c6@leckhampton>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox