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
Any girl who believes that the way to a man's heart is through
his stomach is obviously setting her standards too high.
In response to
pgsql-novice by date
|Next:||From: Mike Ellsworth||Date: 2009-11-23 15:01:59|
|Subject: Anonymous code blocks|
|Previous:||From: richard terry||Date: 2009-11-23 11:11:01|
|Subject: Postgres blob question - insert from basic.|