Search Postgresql Archives

Re: lo_import()

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux