On Mon, 14 Nov 2005, Aaron Steele wrote:
i would like to use lo_import() on the client side to insert images into
postgresql version 8.0.1 on a remote server using psql as follows:
psql -h my.db.host.com <http://my.db.host.com> -U user -c "insert into
binblob (binary_blob) values(lo_import('/path/on/client/machine/ks.jpg'))"
-d mydb
ERROR: must be superuser to use server-side lo_import()
HINT: Anyone can use the client-side lo_import() provided by libpq.
It is one of psql's backslash commands. See \? and \lo_import.
Kris Jurka
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
