Re: [SQL] Blobs

Поиск
Список
Период
Сортировка
Искать
От
Peter Eisentraut
Тема
Re: [SQL] Blobs
Дата
Msg-id
Pine.LNX.4.21.0001242123140.525-100000@localhost.localdomain
Ответ на
Blobs (Neil Cameron)
Список
Дерево обсуждения
Blobs "Neil Cameron" <n.cameron@blueice.co.uk>
Re: [SQL] Blobs Mathijs Brands <mathijs@ilse.nl>
Re: [SQL] Blobs Peter Eisentraut <peter_e@gmx.net>
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)
> 
> Thanks
> 
> Neil@blueice
> 
> 

-- 
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden



В списке pgsql-sql по дате отправления
От: Bruce Momjian
Дата:
Сообщение: Re: [SQL] Backend crash
От: Tom Lane
Дата:
FAQ