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

On 24/03/2010 21:48, Karina Guardado wrote:
> Hi,
>
> Is there a special data type to use to store a lot of text and tables of
> data in a column or attribute?

For large amounts of text, just use the TEXT data type:

    http://www.postgresql.org/docs/8.4/static/datatype-character.html

Not sure what you mean by "tables of data".

Ray.


--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie

Table 9-25. Date/Time Operators

On 24/03/2010 22:01, Karina Guardado wrote:
> for example something like the following :
>
> *Table 9-25. Date/Time Operators*
>
> Operator    Example    Result
> +     date '2001-09-28' + integer '7'    date '2001-10-05'
> +     date '2001-09-28' + interval '1 hour'    timestamp '2001-09-28 01:00:00'
> +     date '2001-09-28' + time '03:00'     timestamp '2001-09-28 03:00:00'
> +     interval '1 day' + interval '1 hour'    interval '1 day 01:00:00'
> +     timestamp '2001-09-28 01:00' + interval '23 hours'    timestamp
> '2001-09-29 00:00:00'
> +     time '01:00' + interval '3 hours'    time '04:00:00'
> -     - interval '23 hours'    interval '-23:00:00'
> -     date '2001-10-01' - date '2001-09-28'     integer '3'
> -     date '2001-10-01' - integer '7'    date '2001-09-24'
> -     date '2001-09-28' - interval '1 hour'    timestamp '2001-09-27 23:00:00'
> -     time '05:00' - time '03:00'    interval '02:00:00'
> -     time '05:00' - interval '2 hours'     time '03:00:00'
> -     timestamp '2001-09-28 23:00' - interval '23 hours'    timestamp
> '2001-09-28 00:00:00'
> -     interval '1 day' - interval '1 hour'    interval '1 day -01:00:00'
> -     timestamp '2001-09-29 03:00' - timestamp '2001-09-27 12:00'    interval
> '1 day 15:00:00'
> *     900 * interval '1 second'    interval '00:15:00'
> *     21 * interval '1 day'     interval '21 days'
> *     double precision '3.5' * interval '1 hour'    interval '03:30:00'
> /     interval '1 hour' / double precision '1.5'    interval '00:40:00'
>
>
>
> is it possible? or is better to use an atached file and store it ? and
> what should be the data type to store a file that can be xls, doc, pdf
> for example.

Sorry, I still don't get it... what *exactly* are you trying to do?

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie

On 24/03/2010 22:01, Karina Guardado wrote:

> what should be the data type to store a file that can be xls, doc, pdf
> for example.

Sorry, I missed this bit - for binary files you can use the bytea type.
Look under "Binary data types" in the docs.

Ray.


--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie

Reciba un respetuoso saludo y deseo de éxitos en sus actividades. El motivo de la presente es para solicitarle se realice una corrección en el plan de mantenimiento preventivo y correctivo de fotocopiadoras, duplicadores e impresoras debido a que en el Centro de Cómputo aparecen, según el reporte, 4 impresoras asignadas y en realidad solamente tenemos dos que son las que detallo a continuación:

I hope this help,

thanks a lot,

karina

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

help

On 29/03/2010 15:43, 赤松 建司 wrote:
> help

Surely. What with? :-)

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie