Re: Postgres blob question - insert from basic. - Mailing list pgsql-novice

From Jean-Yves F. Barbier
Subject Re: Postgres blob question - insert from basic.
Date
Msg-id 4B0A96A0.2050904@gmail.com
Whole thread Raw
In response to Postgres blob question - insert from basic.  (richard terry <rterry@pacific.net.au>)
Responses Re: Postgres blob question - insert from basic.
List pgsql-novice
richard terry a écrit :
> I'm confused about permissions to use lo_import/export:
...

got the same on command line as a user: must be SU to use lo_import.

but why don't U use a BYTEA (upper size limit is 1GB instead of 2GB,
but I doubt U have such large objects).

on command line, it works as a user:
INSERT INTO fruit ('tst', '/tmp/australia_land_of_dragons.png');
INSERT 0  1

JY
--
Any girl who believes that the way to a man's heart is through
his stomach is obviously setting her standards too high.

pgsql-novice by date:

Previous
From: richard terry
Date:
Subject: Postgres blob question - insert from basic.
Next
From: Mike Ellsworth
Date:
Subject: Anonymous code blocks