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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | A.Bhuvaneswaran | 2003-07-25 09:53:34 | Re: Get the last record alone from the select statement. |
Previous Message | Jim Louis | 2003-07-25 07:13:27 | Where's The Primary Key? |