Re: How to store text files in the postgresql?

From: Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
To: DimitryASuplatov <genesup(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: How to store text files in the postgresql?
Date: 2009-06-07 16:41:38
Message-ID: FB7D331E-81C1-4FDC-A4B9-E4C29165586B@hi-media.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

Le 6 juin 09 à 12:41, DimitryASuplatov a écrit :
> My task is to store a lot (10^5) of small ( <10 MB) text files in the
> database with the ability to restore them back to the hard drive on
> demand.

The following article deals specifically with files containing XML but
goes as far as explaining exactly what to change to have it more
general:

http://blog.rhodiumtoad.org.uk/2009/02/05/reading-xml-files-into-the-database/

Regards,
--
dim

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Shakil Shaikh 2009-06-07 18:33:25 Using ANY()
Previous Message Grzegorz Jaśkiewicz 2009-06-07 15:34:47 Re: xml to table (as oppose to table to xml)