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

[Karina Guardado <kguardado@xxxxxxxxx>]

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.

On Wed, Mar 24, 2010 at 3:55 PM, Raymond O'Donnell <rod@xxxxxx> 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@xxxxxx