On Thu, Feb 23, 2006 at 01:24:43PM +0530, sandhya wrote:
> Is there any possibility to delete /Unlink a group of large objects at a time?
> Please tell me .To test my application i have loaded somany files into database.
> Now i want to unlink all those objects.
You could call lo_unlink() in a query. Example:
SELECT lo_unlink(loid) FROM (SELECT DISTINCT loid FROM foo) AS s;
See also contrib/vacuumlo, which will automatically remove large
objects that aren't referenced anywhere.
--
Michael Fuhr