Re: data type to store a lot of text and tables of data

From: Karina Guardado <kguardado(at)gmail(dot)com>
To: rod(at)iol(dot)ie
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: data type to store a lot of text and tables of data
Date: 2010-03-25 14:30:39
Message-ID: 4a92b0c31003250730t50dce085ia36ac110a2f0fec0@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thank you very much for your help and so soon answears. I will try using
the solutions you suggest.

best regards,

karina

On Wed, Mar 24, 2010 at 4:44 PM, Raymond O'Donnell <rod(at)iol(dot)ie> wrote:

> On 24/03/2010 22:39, Karina Guardado wrote:
> > You know I need to design a table where some attributes have a data type
> > that allow me to store text mixed with tables and other information. I
> > use PHP code to get the information and store it in to the database so I
> > wonder if this is posible to do. I found in the link you provided me
> > that If character varying is used without length specifier, the type
> > accepts strings of any size. So this is useful for me when only text has
> > to be stored but when the user wants to store information mixed with
> > tables like the following :
>
> I suppose it depends on what the format of the data is.... the example
> you posted is HTML, which is pure text, so could be stored in a VARCHAR
> or TEXT column.
>
> Ray.
>
>
> --
> Raymond O'Donnell :: Galway :: Ireland
> rod(at)iol(dot)ie
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Karina Guardado 2010-03-25 14:39:11 Re: find a string contained in an attribute
Previous Message tv 2010-03-25 13:58:07 Re: How many Mandatory Process are there in Postgres