lo_read?? - Mailing list pgsql-general

From bdamato
Subject lo_read??
Date
Msg-id 3597E7D1.FD0B4F11@coxtarget.com
Whole thread Raw
List pgsql-general
i have been able to import large objects into my database using

psql -c "insert into foo VALUES ('info', 'more info',
lo_import('/path/to/file'))"

where the last field in foo is an Oid.

How do i read that large object using psql?
i suspected it would be something like...

psql -c "select (lo_read(Oid)) from foo"

but I was wrong. Has anyone done this with psql?

bobd


pgsql-general by date:

Previous
From: Brian
Date:
Subject: Re: [GENERAL] vacuuming
Next
From: Roman Volkoff
Date:
Subject: unsubscribe