Re: Oid data type question

On Thu, 13 Apr 2000, Farren Isaacs wrote:

> I'm relatively new to psql.  I have created a database with Oid data
> types
> in it.  I am now trying to populate the tables with data, from a file
> but
> I am not sure how to get the path names into the Oid fields.  I have
> tried
> commands like:
>
> insert into gene values('cI', '1', lo_import('filename1'),
> lo_import('filename2'), 'control');

 A lo_xxxxx() in standard query works on backend's host disk only.

 a example:

test=# create table tab (data text, lo oid);
CREATE
test=# insert into tab values ('my new data', lo_import('/tmp/aaa'));
INSERT 179545 1
test=# select * from tab;
    data     |   lo
-------------+--------
 my new data | 179531
(1 row)


 If you want use LO in backend<->frondend connection you must use LO API
(example in C/PHP/Perl..etc) or you can use new (7.0) pgsql client.


                            Karel