I have a problem with importing documents into PostgreSQL. I have a
plpgsql function, which simplified could look like this:
create function add_file(flag integer, sth varchar) returns void as begin if flag = 1 then insert into tab_one values (my_file_oid, sth); else insert into tab_two values (my_file_oid, sth); end if; end;
I'm using the
Both the function and the
lo_import command are in the same .sql file.
I cant change the
lo_import() to an
INSERT statement, becouse I need client-site
lo_import. There is variable
LASTOID, but it is not avaible in the
add_file function, and it wouldnt get updated updating on every call
So, how can I insert a large object into the database with, in our example, 'flag' and 'sth' by insert statement and everything in function with arguments?
The file to be loaded is on the client computer.