Re: Postgres and longblob

Disclaimer, I haven't used posgresql yet. Chris Lee wrote: > > 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 ); You'll find info about postgresql datatypes here: http://www.postgresql.org/devel-corner/docs/postgres/datatype.htm The closest to a blob is text, as far as I can ascertain. (http://www.postgresql.org/devel-corner/docs/postgres/character-types.htm) To store your data in this field you might probably do some wizardry with the data you wish to store. According to Tim Perdue (http://www.phpbuilder.net/columns/tim20001112.php3?page=2) only the latest release of PostgreSQL supports ROW sizes larger than 8k (I can't verify that a, this was a problem nor b, that it is solved). > I don't want to re-write a large amount of code, Ive allready got over > 30,000 images in my MySQL db. A script would surely serve to move those images to the file system? But that would probably break your existing application. -- Paul K Egell-Johnsen Developer/PR Manager zez.org: about code http://zez.org/