user2793872
user2793872

Reputation: 319

How to store imagefile in a table

I have table like blow

create table txn_images(id integer imagename oid );

i want to insert images

my query is like

insert into txn_image values(100,lo_import('/home/ramesh/Downloads/index.jpeg'));

it through error like "could not open server file "index.jpeg": No such file or directory"

Upvotes: 0

Views: 60

Answers (1)

Helping Hand..
Helping Hand..

Reputation: 2440

btea

Large Object

use either of 1 Data-Type..

Upvotes: 1

Related Questions