Home > mailing lists

Blobs - Mailing list pgsql-sql

From	Neil Cameron
Subject	Blobs
Date	January 24, 2000 12:50:33
Msg-id	011a01bf66bb$2483d400$03c6c6c6@leckhampton Whole thread Raw
Responses	Re: [SQL] Blobs (Mathijs Brands <mathijs@ilse.nl>) Re: [SQL] Blobs (Peter Eisentraut <peter_e@gmx.net>)
List	pgsql-sql

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

From: Patrik Kudo
Date: 24 January 2000, 08:01:30
Subject: Re: [SQL] Duplicate tuples with unique index

From: Mathijs Brands
Date: 24 January 2000, 13:55:34
Subject: Re: [SQL] Blobs