| From: | Craig Ringer <craig(at)postnewspapers(dot)com(dot)au> |
|---|---|
| To: | Vikram A <vikkiatbipl(at)yahoo(dot)in> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: File Handling in pgsql |
| Date: | 2010-04-12 09:50:08 |
| Message-ID: | 4BC2ECD0.2010900@postnewspapers.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 12/04/10 17:17, Vikram A wrote:
> Hi,
> I would like to store the files(.doc, .xls , images, vedios) in the
> postgresql data base as a field.
If you really want to store them in the database your options are a
bytea field (warning: size limits) or a large object. See the manual.
Do you really need ACID-compliant access to your files? Have you
considered storing just the paths to the files in the database, and the
files themselves externally to the database in the file system? This is
MUCH more efficient if you don't need the facilities the database requires.
There has been lots of discussion of this in the past on this list, so
consider searching the mailing list archives and Google.
--
Craig Ringer
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ben Martin | 2010-04-12 09:52:05 | Re: Creating a read/write virtual table? |
| Previous Message | Vikram A | 2010-04-12 09:17:40 | File Handling in pgsql |