RE: a very big field - Mailing list pgsql-general

From Nikolay Mijaylov
Subject RE: a very big field
Date
Msg-id NDBBJGGFCKKJGOBKEGACOEACCDAA.nmmm@nmmm.nu
Whole thread Raw
In response to a very big field  (Fernando Caamaño <fernando@interweb-research.net>)
List 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 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

pgsql-general by date:

Previous
From: "Melchior, Tim"
Date:
Subject: Want to run PostgreSQL on new associative memory technology
Next
From: Fernando Caamaño
Date:
Subject: RE: a very big field