Re: [ADMIN] pg_lo_import alternative ...

2003-11-29 Thread Kent L. Nasveschuk
Your method sounds very interesting for storing images. I'd be interested in knowing what other attributes you store with the images. My interest in storing images is for documents that pertain to personnel records such as copy of certifications, licenses, diploma, training courses, personnel evalu

Re: [ADMIN] pg_lo_import alternative ...

2003-11-28 Thread Adam Ruth
mber 26, 2003 02:20 PM To: 'Daniel Rubio', [EMAIL PROTECTED] Subject: Re: [ADMIN] pg_lo_import alternative ... Are there many images? I do not suggest to store the images in the database. Better save them on the disk and in the database save only the path to the image. Think also to the

Re: [ADMIN] pg_lo_import alternative ...

2003-11-27 Thread Andrei Bintintan
dy needs it just say. Best regards. Andy. - Original Message - From: "Rudi Starcevic" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, November 27, 2003 6:51 AM Subject: Re: [ADMIN] pg_lo_import alternative ... > Hi, > > > Anyone that that is u

Re: [ADMIN] pg_lo_import alternative ...

2003-11-26 Thread Rudi Starcevic
Hi, > Anyone that that is using Postgres for storage and retrival of > images please post your experiences. I've been very happy with a web application I built which stores images in Postgresql in text format. I use PHP to base_64 encode the binary image file into a text string and store that.

Re: [ADMIN] pg_lo_import alternative ...

2003-11-26 Thread Adam Ruth
mber 26, 2003 02:20 PM To: 'Daniel Rubio', [EMAIL PROTECTED] Subject: Re: [ADMIN] pg_lo_import alternative ... Are there many images? I do not suggest to store the images in the database. Better save them on the disk and in the database save only the path to the image. Think also to the

Re: [ADMIN] pg_lo_import alternative ...

2003-11-26 Thread kent
ences. Thank you. >-Original Message- >From: Andrei Bintintan [mailto:[EMAIL PROTECTED] >Sent: Wednesday, November 26, 2003 02:20 PM >To: 'Daniel Rubio', [EMAIL PROTECTED] >Subject: Re: [ADMIN] pg_lo_import alternative ... > >Are there many images? > >I

Re: [ADMIN] pg_lo_import alternative ...

2003-11-26 Thread Andrei Bintintan
. - Original Message - From: "Daniel Rubio" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, November 26, 2003 3:58 PM Subject: [ADMIN] pg_lo_import alternative ... > Hi all. > > One of our clients wants to store images into his postgres database > host

[ADMIN] pg_lo_import alternative ...

2003-11-26 Thread Daniel Rubio
Hi all. One of our clients wants to store images into his postgres database hosted by us. To do this is trying to use the PHP function pg_lo_import, receiving this error message from server: Waning: pg_query() [function.pg-query]: Query failed: ERROR: You must have Postgres superuser privileg