Skip site navigation (1) Skip section navigation (2)

Re: question about images

From: Dag Gullberg <dag(dot)gullberg(at)telia(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: question about images
Date: 2003-07-25 09:06:00
Message-ID: 03072511060000.01342@hemma (view raw or flat)
Thread:
Lists: pgsql-novice
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

In response to

pgsql-novice by date

Next:From: A.BhuvaneswaranDate: 2003-07-25 09:53:34
Subject: Re: Get the last record alone from the select statement.
Previous:From: Jim LouisDate: 2003-07-25 07:13:27
Subject: Where's The Primary Key?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group