Skip site navigation (1) Skip section navigation (2)

Re: lo_export

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Steve Tucknott <steve(at)retsol(dot)co(dot)uk>
Cc: PostGreSQL <pgsql-novice(at)postgresql(dot)org>
Subject: Re: lo_export
Date: 2004-11-18 18:40:55
Message-ID: 18571.1100803255@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
Steve Tucknott <steve(at)retsol(dot)co(dot)uk> writes:
> We have images stored in the database, that our application allows the
> user to export (using lo_export), update, and then reimport. How do I
> get around the permissions issue?

Do the lo_export and lo_import on the client side, not the server side.
IIRC psql has a "\lo_export" command, and there's definitely a function
for it in libpq.

			regards, tom lane

In response to

  • lo_export at 2004-11-18 17:56:33 from Steve Tucknott

pgsql-novice by date

Next:From: Tom LaneDate: 2004-11-18 18:45:15
Subject: Re: multi-homed box
Previous:From: Aarni RuuhimäkiDate: 2004-11-18 18:35:38
Subject: Re: Querying a list of values

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group