Re: [GENERAL] File Handling in pgsql

2010-04-12 Thread Craig Ringer
On 12/04/10 17:58, Vikram A wrote: Thank you for the valuable reply. If i go for the path store rather than the bytea. The disk sever [where files are stored] must be live always? Well, if it's down or inaccessible then so are your files, but it won't stop the database its self from working.

Re: [GENERAL] File Handling in pgsql

2010-04-12 Thread Vikram A
April, 2010 3:20:08 PM Subject: Re: [GENERAL] File Handling in pgsql 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 by

Re: [GENERAL] File Handling in pgsql

2010-04-12 Thread Craig Ringer
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

[GENERAL] File Handling in pgsql

2010-04-12 Thread Vikram A
Hi, I would like to store the files(.doc, .xls , images, vedios) in the postgresql data base as a field. Is postgres is supporting such kind of activities? Or In what way i can do so? Please guide me. Thank you in advance, Vikram A