From: Joshua D. Drake <jd@commandprompt.com>
To: Chris Hoover <revoohc@sermonaudio.com>
Cc: PostgreSQL Admin <pgsql-admin@postgresql.org>
Subject: Re: Best way to store files inside db
Date: Wed, 13 Apr 2005 10:41:07 -0700
Message-ID: <425D59B3.4000207@commandprompt.com> (raw)
In-Reply-To: <425D5180.6020109@sermonaudio.com>
References: <425D5180.6020109@sermonaudio.com>
Chris Hoover wrote:
> I am looking for some help/advice. We need to store some files inside
> postgres (at least it has been requested of us). What is the best way
> to do this? Right now, the files are all human readable text files, but
> that could change.
It depends on the size of the files. If the files are all reasonably
small then bytea is a fine solution. However if you are going to be
storing 5 meg PDF or some such thing I would suggest Large Objects.
> How can I do this? I am thinking to store unmodified, I'll have to use
> a bytea field. However, how do I tell the database to insert a file
> (say "c:\test.txt") into the table?
http://www.postgresql.org/docs/8.0/interactive/largeobjects.html
ALl the language APIs have similar functions.
Sincerely,
Joshua D. Drake
--
Your PostgreSQL solutions provider, Command Prompt, Inc.
24x7 support - 1.800.492.2240, programming, and consulting
Home of PostgreSQL Replicator, plPHP, plPerlNG and pgPHPToolkit
http://www.commandprompt.com / http://www.postgresql.org
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: jd@commandprompt.com, revoohc@sermonaudio.com
Subject: Re: Best way to store files inside db
In-Reply-To: <425D59B3.4000207@commandprompt.com>
References: <425D5180.6020109@sermonaudio.com> <425D59B3.4000207@commandprompt.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox