RE: a very big field
| От | Nikolay Mijaylov |
|---|---|
| Тема | RE: a very big field |
| Дата | |
| Msg-id | NDBBJGGFCKKJGOBKEGACOEACCDAA.nmmm@nmmm.nu обсуждение исходный текст |
| Ответ на | a very big field (Fernando Caamaño <fernando@interweb-research.net>) |
| Список | pgsql-general |
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@hub.org [mailto:pgsql-general-owner@hub.org]On Behalf Of Fernando Caamaño
Sent: Monday, June 05, 2000 5:45 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] a very big fieldHi 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...
В списке pgsql-general по дате отправления: