Re: storing large amounts of text

From: Paul Dlug <paul(at)nerdlabs(dot)com>
To: Stephan Richter <srichter(at)cbu(dot)edu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: storing large amounts of text
Date: 2000-04-22 21:06:20
Message-ID: 3902144C.12DCB14C@nerdlabs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I thought TEXT had a limit of 8K or something around that size, I would
need something larger.

Stephan Richter wrote:
>
> At 08:19 PM 4/22/00 +0000, Paul Dlug wrote:
> >I'm sure this has come up before because it just logically seems like
> >others would have run up against this too. Is it possible to store a
> >large amount of text in a row/field? I want to store articles in the
> >database along with information about them, sort of a content databasing
> >system. Can anyone reccommend a good way to go about doing this in
> >Postgres? Any and all help greatly appreciated.
>
> The TEXT type will help you or do you look for something else?
>
> CREATE TABLE foo (
> id int8,
> content text);
>
> Regards,
> Stephan
> --
> Stephan Richter - (901) 573-3308 - srichter(at)cbu(dot)edu
> CBU - Physics & Chemistry; Framework Web - Web Design & Development
> PGP Key: 735E C61E 5C64 F430 4F9C 798E DCA2 07E3 E42B 5391

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Richter 2000-04-22 21:54:42 Re: storing large amounts of text
Previous Message Paul Dlug 2000-04-22 20:19:05 storing large amounts of text