Re: data type to store a lot of text and tables of data - Mailing list pgsql-general

From Raymond O'Donnell
Subject Re: data type to store a lot of text and tables of data
Date
Msg-id 4BAA95DC.3030707@iol.ie
Whole thread Raw
In response to Re: data type to store a lot of text and tables of data  (Karina Guardado <kguardado@gmail.com>)
Responses Re: data type to store a lot of text and tables of data  (Karina Guardado <kguardado@gmail.com>)
List pgsql-general
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@iol.ie

pgsql-general by date:

Previous
From: Karina Guardado
Date:
Subject: Re: data type to store a lot of text and tables of data
Next
From: william wayne
Date:
Subject: boualem guechtouli