RE: a very big field

your english is fine

you can use BLOb field , but they are very strange and little confuse in
pgsql. your db directory will be filled with indexes and so on.

I recommend that you are use text files, and to store name in db char field.
or to use filenames that refer to key.

|id|...|
| 1|...|
| 2|...|

$ls /www/newsstore/
news.1.txt
news.2.txt
$

this directory can be in your www root, or outside it. If its outside you
can include these files into the respond web page (PHP require or
<!--#include )

Nikolay
-----Original Message-----
From: pgsql-general-owner(at)hub(dot)org [mailto:pgsql-general-owner(at)hub(dot)org]On
Behalf Of Fernando Caamaño
Sent: Monday, June 05, 2000 5:45 PM
To: pgsql-general(at)postgresql(dot)org
Subject: [GENERAL] a very big field

Hi all, I have to store news in a postgres database, and my problem is
that when I try to insert a very big news, it tolds me that it can't store
it becuase it is to big, this news are 6 pages long in a ms-word document. I
have definde this field as text, exists any other type for data storage that
allows bigest size?
thank you and sorry for my bad english...
Fernando Caamaño
Programador web
Interweb Research
www.interweb-research.net