Re: question about images

torsdagen den 24 juli 2003 16:06 skrev Tom Lane:
> Dag Gullberg <dag(dot)gullberg(at)telia(dot)com> writes:
> > I have a problem with understanding how BLOB's
> > work in postgres. It seems as thoug I have to use
> > COPY BINARY table (imagefield) FROM 'absolutepath+imagename' ;
>
> No, what you want is lo_import().
>
> regards, tom lane

Wanting to share the novice discovery of things that is well
known to you buffs I now can say that my problems are very neatly
solved by using the pgsql module in php (type lo_import() access).

Anybody out there have a similar problem the postgres JDBC doc
may help if you are going in that direction. If php and "native"
postgress access is wanted, see (e.g.)

http://se.php.net/manual/en/function.pg-lo-create.php

All in a box, as it were .....

DagG