Re: How to store text files in the postgresql? - Mailing list pgsql-general

From Leif B. Kristensen
Subject Re: How to store text files in the postgresql?
Date
Msg-id 200906061241.36191.leif@solumslekt.org
Whole thread Raw
In response to How to store text files in the postgresql?  (DimitryASuplatov <genesup@gmail.com>)
List pgsql-general
On Saturday 6. June 2009, DimitryASuplatov wrote:
>Hello,
>
>I am very new to postgresql database. I`ve used a little of MySql
>previously.
>
>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.
>
>That means that I need two functions. First - grab file from the
>directory, store it in the database and delete from the disk; second -
>recreate in back to the disk.
>
>1/ Is it possible?
>2/ Could you give me some quick tips on how to manage it from the
> start so that I knew what to look for in the manual?
>
>Thank you for your time.
>Dimitry

About 15 lines of Perl code should do that.
--
Leif Biberg Kristensen | Registered Linux User #338009
Me And My Database: http://solumslekt.org/blog/

pgsql-general by date:

Previous
From: DimitryASuplatov
Date:
Subject: How to store text files in the postgresql?
Next
From: Raymond O'Donnell
Date:
Subject: Re: How to store text files in the postgresql?