Skip site navigation (1) Skip section navigation (2)

Re: storing a text file

From: Mag Gam <magawake(at)gmail(dot)com>
To: Joshua Tolley <eggyknap(at)gmail(dot)com>
Cc: PostgreSQL List - Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: storing a text file
Date: 2010-02-15 18:26:29
Message-ID: 1cbd6f831002151026i6a951526k222726175e3ab6bf@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
Thanks.

I would like to load an entire text file into a field of a table.Is
there an easy way to do this or do I have to write a script?

TIA



On Sun, Feb 14, 2010 at 2:29 PM, Joshua Tolley <eggyknap(at)gmail(dot)com> wrote:
> On Sun, Feb 14, 2010 at 09:39:13AM -0500, Mag Gam wrote:
>> I would like to index several documents. They are all text files, I
>> was wondering what is the best way to do this. I was thinking to have
>> a column which will have:
>>
>> *docid (serial)
>> date (timestamp)
>> document (varchar)
>>
>> Eventually, I would like to access these documents via a webbrowser
>> and I would like to search these documents. Each document is about 10
>> to 20kb in size.
>>
>> My question is, what datatype would be ideal for "document" field?
>> Also, any thoughts and recommendations ?
>
> Make it a TEXT type. You can use PostgreSQL's full text search options for
> searching across the set of all documents for given words or phrases.
>
> --
> Joshua Tolley / eggyknap
> End Point Corporation
> http://www.endpoint.com
>
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.9 (GNU/Linux)
>
> iEYEARECAAYFAkt4Tx4ACgkQRiRfCGf1UMPaTgCfVuDbj4m4V5DFv8reLC3KwP8L
> XLkAniJqkT7Q/xSrXOdjBG+9s9S6dyk8
> =uuon
> -----END PGP SIGNATURE-----
>
>

In response to

Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2010-02-16 04:25:36
Subject: Re: Actions requiring commit
Previous:From: Joshua TolleyDate: 2010-02-15 17:57:02
Subject: Re: Dily health checks to be created in short time

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group