pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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



view thread (2+ messages)

Message-ID: <425D59B3.4000207@commandprompt.com>
Permalink:  ../425D59B3.4000207@commandprompt.com/
Also on:    postgresql.org/message-id/425D59B3.4000207@commandprompt.com

 · 

reply

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