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-24 22:01:48 |
Message-ID: | 4a92b0c31003241501s7582c8d0h6b57cde596b9b613@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
for example something like the following :
*Table 9-25. Date/Time Operators*
OperatorExampleResult + 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.
On Wed, Mar 24, 2010 at 3:55 PM, Raymond O'Donnell <rod(at)iol(dot)ie> wrote:
> 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(at)iol(dot)ie
>
From | Date | Subject | |
---|---|---|---|
Next Message | Raymond O'Donnell | 2010-03-24 22:04:04 | Re: data type to store a lot of text and tables of data |
Previous Message | Carlo Stonebanks | 2010-03-24 22:00:59 | Re: How to dump JUST procedures/funnctions? |