Re: How to insert into pg_largeobject?

On Thu, Sep 4, 2008 at 4:25 AM, Ognjen Blagojevic <ognjen(at)etf(dot)bg(dot)ac(dot)yu> wrote:
> Hi,
>
> How can I insert data into pg_largeobject?
>
> When I try:
>
> INSERT INTO pg_catalog.pg_largeobject(loid, pageno, data) VALUES (4, 1,
> '\\001\\002\\003\\004');

This isn't meant to be used like this, I don't think. You'll want to
use the large object interface:

http://www.postgresql.org/docs/8.3/static/lo-funcs.html

Sean