Re: Re: [PHP] Postgres and longblob

See pg_loimport in the php manual. As far as I know, pgsql doesn't support BLOBs in a SQL standard manner (are blobs even a standard in any SQL spec?) and certainly arn't part of a specific table. I was aproaching the use of blobs in my pgsql database, but I couldn't figure out how to get db_dump to back up the blobs (with their OID). I posted questions along this line several times to the pgsql mail lists and never got a response. I switched to the aproach of storing my files in the filesystem, but then I didn't have an existing 30,000 files to deal with.... Chris On Thu, 30 Nov 2000, Richard Lynch wrote: > Date: Thu, 30 Nov 2000 20:03:53 -0600 > To: <php-general@lists.php.net> > From: "Richard Lynch" <richard@zend.com> > Subject: Re: [PHP] Postgres and longblob > > You probably would be better off moving all the images into your file > system > instead of bloating your database... > > PostgreSQL certainly has some sort of large binary data -- I forget > what > it's called. > > http://postgresql.org/ > > > ----- Original Message ----- > From: "Chris Lee" <lee@mediawaveonline.com> > Newsgroups: php.general > Sent: Thursday, November 30, 2000 5:06 PM > Subject: [PHP] Postgres and longblob > > > > I know this isnt a php question, but still hope I can get an > answer. > > > > Im playing with Postgres for the first time and it it sais it > doesn't > > know what a longblob or blob is. > > > > CREATE TABLE table1 ( stockno INT, image LONGBLOB ); > > > > I don't want to re-write a large amount of code, Ive allready got > over > > 30,000 images in my MySQL db. > > > > Chris Lee > > Mediawaveonline.com > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > > For additional commands, e-mail: php-general-help@lists.php.net > > To contact the list administrators, e-mail: > php-list-admin@lists.php.net > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: > php-list-admin@lists.php.net > -- Earnest HemmingWay wrote: "The world is a fine place, and worth fighting for" I agree with the second part.