Re: How to insert into pg_largeobject? - Mailing list pgsql-novice

From Sean Davis
Subject Re: How to insert into pg_largeobject?
Date
Msg-id 264855a00809040456l44dd5622m3d95e4bbc5df67ff@mail.gmail.com
Whole thread Raw
In response to How to insert into pg_largeobject?  (Ognjen Blagojevic <ognjen@etf.bg.ac.yu>)
List pgsql-novice
On Thu, Sep 4, 2008 at 4:25 AM, Ognjen Blagojevic <ognjen@etf.bg.ac.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

pgsql-novice by date:

Previous
From: Ognjen Blagojevic
Date:
Subject: How to insert into pg_largeobject?
Next
From: Yogesh Sharma
Date:
Subject: Re: Opinion from experts