Re: Postgres blob question - insert from basic.

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.